Select Selected Cell in Different Sheet

[misiek5510]

I'm trying to do a simple thing as above however can't seem to find an answer.
Basically If I select C5 for example and run the macro I'd like it to go to a different sheet/tab and select the exact same cell.

Below works but only if I specify the cell the cell prior, and I'd like it to be dynamic.

Range("C5").Select
Sheets("Comments").Select
Range("C5").Select

 

[steve the fish]

Hi. Could you give us more? You rarely need to select a cell in VBA.

 

[Fluff]

Hi & welcome to MrExcel.
How about

   Application.Goto Sheets("Comments").Range(ActiveCell.Address)

 

[misiek5510]

This worked amazing. Thank you!

 

[steve the fish]

You rarely need to select a cell in VBA mind... reason you dont is its slow.

 

[Fluff]

Glad we could help & thanks for the feedback.