View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wester Wester is offline
external usenet poster
 
Posts: 7
Default Copy Sheet Names to a Column

Disregard 1st question, I found the solution in another post.

New question and pretty simple one (but not for me... Krikee). How do I
jump to or select a specific sheet in my workbook so my macro will always run
on that one sheet.

Sheets("Code Master").Activate
Sheets("Code Master").Select

Any help would be appreciated.

Thanks!

-Wesley


"Wester" wrote:

Hi,

Struggling with the command/macro to copy all sheet names in my workbook to
single column on a 'master' sheet.

Any help would be apprecieted.

-Wesley