Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select method of Range class failed error message
Hope inSitLastColumn and insitelastrow are dimensioned as Long..
Set insiteWS = Worksheets("InSite Data") Set rngInsitehdr = insiteWS.Range("A2", Cells(insitelastColumn, insitelastRow)) 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 | |||
Select method of Range class failed error message | Excel Programming | |||
Excel VBA error - Select method of Range class failed | Excel Programming | |||
Run-time error '1004': Select method of Range class failed | Excel Programming | |||
Select method of range class failed, Run time error 1004 | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |