to change it once
> in my routine.
>
> also, see my notes below:
>
>
>
> ____________________
>
> From: Nasim
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, February 15, 2011 11:37:11 AM
> Subject: Re: $$Excel-Ma
y 15, 2011 11:37:11 AM
Subject: Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not
sheet with index2
--
this should be:
Thisworkbook.sheetS("whatever").select
--
as the array.
>
> Because of this, using sheets(1) or Sheets(2) is inconsistent, and I NEVER use
> it.
> (some of my macros delete and create several sheets during processing. It's
> not
> uncommon to be up to sheet300 in a session).
>
> What I would suggest is to u
.
What I would suggest is to use:
Sheets("Name1") or set a variable for the sheet name
ShtName = "Name3"
and use:
Sheets(ShtName).Select
Paul
____________________
From: Nasim
To: MS EXCEL AND VBA MACROS
Sent: Mon, February 14, 2011 6:02:46 PM
Subject: $$Excel-Macr
Hi,
we are using excel 2010. I use sheets(2) in my code and it was working
fine (since this was the 2nd tab in my file till I manually added
another sheet and I moved this 3rd sheet betwenn sheet 1 and 2 so now
3rd sheet is in 2nd order in my file(2nd tab). I have renamed the tabs
ofcourse and the