Sheets("sheet_name").Select

[eramsva]

Hi all,

Is it possible to use the Sheets.Select function but instead of specifying the sheet name, specify the sheet which was active when I started the macro?

What I want to do is to do a Macro where a update all Pivots in workbook, from different sheets. After the macro, then I want to return to the sheet from where I run the macro.

Thanks!

Martin

[HaHoBe]

Hi, Martin,

IŽd recommend not to switch Cells or Worksheets in the course of a macro.

Maybe proceed like this:

Please Login or Register  to view this content.

Alternative:

Please Login or Register  to view this content.

Ciao,
Holger

[TMS]

You'd have to store a reference to the worksheet.

Something like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Regards, TMS