Goto ("A1") in non active sheet

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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 ???
 
I always select that sheet first then select the range.

I'm not using VB, but here is some translation without testing it.

Sheets(s).Select
ActiveSheet.Range("A1").Select
 
Hi SlickUser, i know it works if i activate the sheet but do not want to do
that as i am assuming that it will slow my code down ??
 
Hi Les,

Try something like:

ThisWorkbook.Sheets("s"). _
Range("A1").Value = "Your value"
 
Back
Top