ExcelBanter - change active sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - change active sheet (https://www.excelbanter.com/excel-programming/316071-change-active-sheet.html)

Maileen

change active sheet

Hi,

How can i change the active sheet ?
thanks a lot,
Maileen

Frank Kabel

change active sheet

Hi
you could use
worksheets("sheet2").activate

but why are you trying to do this?

--
Regards
Frank Kabel
Frankfurt, Germany

"Maileen" schrieb im Newsbeitrag
...
Hi,

How can i change the active sheet ?
thanks a lot,
Maileen

Jim Thomlinson[_3_]

change active sheet

sheets("Sheet2").select

Assuming you have a sheet2
"Maileen" wrote:

Hi,

How can i change the active sheet ?
thanks a lot,
Maileen

All times are GMT +1. The time now is 10:43 AM.