Transport you to another sheet VBA

[Alpacino]

What will the code be to transport viewer to another sheet using assigned macro to button. Viewer in sheet 1 to be transported to sheet 4
Regards
Alan

 

[DutchKevin]

Hi Alpacino,
try this

Sheets("Sheet4").Activate   'jumps to sheet4
    Cells(2, 2).Activate            'activates cell B2

Kevin

 

[Alpacino]

Thank you.

 

[poolhall]

Sheet4.Activate

 

[Alpacino]

Thanks peeps. trying to get use to vba. Haha

 

[brettdj]

Sheet4.Activate

This method activates the VBA sheet codename of "Sheet4" - which may or may not be the sheet in index position 4, and it is independent of the sheet tab name

Cheers

Dave

 

[Alpacino]

So does that mean even if I change sheet4 name to datasheet vba will still recognise it as sheet 4.??

 

[brettdj]

Yes - if that is that sheets codename

 

[Alpacino]

I've tried to write this sub
Do u put it into a sub that has already been written ??

 

[DutchKevin]

Hi alpacino,
You can use it either in a new sub or an existing one. It doesn't really matter in my opinion. it could look like this:

Sub changesheet()
Sheets("Sheet4").Activate 'jumps to sheet4
Cells(2, 2).Activate 'activates cell B2
End Sub