Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code is giving me a Run-time error: '9' Subscript out of range:
Dim CDLastRow As Long 'Catalyst Dump Dim EDLastRow As Long 'Exported Data CDLastRow = Workbooks("Test Tally SheetII.xlsm").Worksheets _ ("Catalyst Dump").Cells(Rows.Count, "A").End(xlUp).Row Worksheets("Catalyst Dump").Columns("D").ColumnWidth = 13 Per some previous advice I added the file type to "Test Tally SheetII.xlsm" Since I'm working in 07 and my sheet is saved as .xlsm I used that instead of ..xls. But it locks up on this line still. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |