开发者

Subscript out of range error

Private Sub sendemail(esubj)

    ROW_BEGIN = 1
    ROW_END = 72

    Sheets("Input").Select
    Range("A" & ROW_BEGIN & ":S" & ROW_END).Select
    Range("A" & ROW_BEGIN).Select

    fileL = "\\fire\school\FINANCE\Report\FY10\Ke开发者_开发知识库y Indicator\"
    fileL = fileL & (Left(Range("I7"), 3)) & Right(Year(Date), 2)
    fileL = fileL & "\Key Report - " & myfdate & ".xls"

I have a workbook with a spreadsheet tab named Input. When I try to run it, I get the Subscript out of range message. Why cant it pull from the Input spreadsheet??


Why are you performing all the Selects?

What line does the code fail at?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜