Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Subscript out of Range" Error Msg?
Hi guys, could you pls have a look at my code and let me know why i keep getting this error msg every time i try to execute it? Thanks so much, Maria Sub CommandButtonDRG_Click() Dim i As Integer Dim curCell As Date Dim startDate As Date Dim endDate As Date Dim SheetNumber As Integer SheetNumber = "949" startDate = Sheets(SheetNumber).Range("c2").Value endDate = Sheets(SheetNumber).Range("e2").Value Sheets(SheetNumber).Columns("C:C").Select Selection.NumberFormat = "m/d/yyyy" Sheets(SheetNumber).Range("c2").Select ActiveCell.FormulaR1C1 = startDate i = 3 Do curCell = Sheets(SheetNumber).Cells(i, 3).Select ActiveCell.FormulaR1C1 = "=dvstradedate(R[-1]C,1)" i = i + 1 Loop Until Sheets(SheetNumber).Cells(i - 1, 3).Value = endDate End End Sub -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726 View this thread: http://www.excelforum.com/showthread...hreadid=523076 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming | |||
FileCopy Command Giving "Subscript Out of Range" Error Message | Excel Programming | |||
"Subscript out of range Runtime Error 9" | Excel Programming | |||
SaveAs "subscript out of range" error (COM - SOAP) | Excel Programming | |||
SaveAs "subscript out of range" error (COM - SOAP) | Excel Programming |