selecting worksheet by its index.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ucanalways@gmail.com - 13 Nov 2007 18:32 GMT

Initially I have Sheet1(Sheet3). Later I rename the Sheet 3. Let's
assume it becomes Sheet1(AAA). The name changes periodically. So, I
would like to select it using the sheet's index. What would be the
macro/syntax for this? Thanks

Reply to this Message

Nigel - 13 Nov 2007 18:54 GMT

Sheets(1).Activate

However this relates to the first sheet in the workbook, change it's
position and index number changes. Consider using the codename which can be
set in the VBA Editor.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Initially I have Sheet1(Sheet3). Later I rename the Sheet 3. Let's
> assume it becomes Sheet1(AAA). The name changes periodically. So, I
> would like to select it using the sheet's index. What would be the
> macro/syntax for this? Thanks

Reply to this Message

ucanalways@gmail.com - 13 Nov 2007 19:46 GMT

> Sheets(1).Activate
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Hi.. could you please let me know how to tackle this problem using
something in the lines of

dim wsindex as integer
if wsindex = 1 then
'activate that sheet
end if

Thanks

Reply to this Message

JP - 13 Nov 2007 20:46 GMT

You can just delete the sheet directly by using "Sheets(1).Delete" or
"Sheet1.Delete"

HTH,
JP

On Nov 13, 2:46 pm, ucanalw...@gmail.com wrote:

> Hi.. could you please let me know how to tackle this problem using
> something in the lines of
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message