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

--
Slickuser


"Les" wrote:

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