Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select method of Range class failed error message
Oops. Row should be first ..
Set insiteWS = Worksheets("Sheet1") Set rngInsitehdr = insiteWS.Range("A2", Cells(insitelastRow, insitelastColumn)) rngInsitehdr.Select If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: I have this section of code but I get the above error message whenever I get to the last line: rngInsitehdr.Select I can't figure it out. Any ideas? Thanks. Set insiteWS = Worksheets("InSite Data") Set rngInsitehdr = insiteWS.Range("A2:" & insitelastColumn & insitelastRow) rngInsitehdr.Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA error - Select method of Range class failed | Excel Programming | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
userform error 1004 select method of range class failed | Excel Programming | |||
Run-time error '1004': Select method of Range class failed | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |