Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I must be blind. Please help me find what's the problem with this code.
I get the following error when I run it. "Run-Time error 1004: Application-defined or object-defined error" My code is really simple and yet I don't know what's wrong with it. Dim myArray(1,1) as string c= 1 set s = workbooks("test.xls").sheets(2) Set theRange = s.Range(Cells(1, c), Cells(UBound(myArray), c)) <-run time error on this line Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Generic protect/unprotect code through buttons and code? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |