Goto ("A1") in non active sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Les - 21 May 2008 17:34 GMT

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 ???

Signature

Les

Reply to this Message

Slick user - 21 May 2008 17:42 GMT

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

Signature

Slickuser

> 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
[quoted text clipped - 7 lines]
>
> without success ???

Reply to this Message

Les - 21 May 2008 17:48 GMT

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 ??

Signature

Les

> I always select that sheet first then select the range.
>
[quoted text clipped - 14 lines]
> >
> > without success ???

Reply to this Message

Norman Jones - 21 May 2008 17:53 GMT

Hi Les,

Try something like:

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

---
Regards.
Norman

Reply to this Message