View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Goto ("A1") in non active sheet

Hello all, i have a number of sheets that i am putting data in, but each
sheet is not active when i do that. The sheet name is variable "s", is it
possible to select "A1" on these sheets without activating them ?

I have tried

sheets(s).range("A1").select and

workbooks("Name"").sheets(s")Range("A1").select

without success ???
--
Les