View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Select method of Range class failed error message

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