Worksheets

[Roses8]

Hi,

Is there a way of naming a sheet in a macro so t looks up the name in a cell.

e.g.
in a macro it will be sheet (front page.cellA1).select

As the sheet name will always change, I would like the user the sheet name for the macro to select.

Many thanks.

 

[Richard Schollar]

Hi

You can use the value input into a cell as the name of the sheet the macro selects thus:

WorkSheets(WorkSheets("Front Page").Range("A1").Value).Activate

Richard

 

[Roses8]

Hi thank you.