Specify Cell in Macro

[ingleg]

--------------------------------------------------------------------------------

Hi

The following macro lists all of the worksheets in a spreadsheet:

Please Login or Register  to view this content.

It lists the names starting in cell A1 of the current worksheet, can anyone help move the starting point to another cell, ie B6?

ps, Hopefully this is a suitable title.

[shg]

Here's one way:

Please Login or Register  to view this content.

[dmaesj]

Hope this helps. If you need to start at B1 see comment in code. This will only work if you have the sheet you want the names in as the active sheet at time of macro execution.

Please Login or Register  to view this content.

[ingleg]

Here's one way:

Thank you!