| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Goto ("A1") in non active sheet
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Goto ("A1") in non active sheet
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 ?? -- Les "Slick user" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Goto ("A1") in non active sheet
Hi Les,
Try something like: ThisWorkbook.Sheets("s"). _ Range("A1").Value = "Your value" --- Regards. Norman "Les" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active sheet instead of a "sheet1" for Macro | Excel Worksheet Functions | |||
| On Errror Goto Error handler only works first time through "For Each" cycle | Excel Programming | |||
| Save active sheet as "filename" on a remote server with username and password | Excel Programming | |||
| Macro to run on the "Active Sheet" | Excel Discussion (Misc queries) | |||
| Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
Hybrid Mode
