Vba indirect sheet name

Hi, so basically I’m trying to get vba to reference to a cell to determine what page to target. Any idea how?

So for example..
Worksheets("this will be the worksheet cell reference>’MOI USER Report!D3’").Activate
But I have no idea how to word it.

Thanks

You have to activate the related sheet and then select the range.

Such as;

Please Login or Register  to view this content.

Originally Posted by Haluk

You have to activate the related sheet and then select the range.

Such as;

Please Login or Register  to view this content.

On sheet moi user in cell d3 is the sheet name that I want vba to read and use that to target a certain sheet every time I change it. So I’ll change the cell d3 to January then run macro and it will target sheet January or if I change d3 to February it will target sheet February when I run the macro. Tried to explain it as clear as I can but if it’s not enough then let me know

I’ll try this tomorrow but yeah that’s the idea! Thanks

Or if your sheet names are numbers

Please Login or Register  to view this content.