View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bmac bmac is offline
external usenet poster
 
Posts: 30
Default Macro Copy Worksheet Name into worksheet A1

I have a 50 page workbook. I would like to create a macro to copy each
Worksheet name into each of their perspective A1 cells.

A1 in worksheet1 would display Worksheet1
A1 in worksheet2 would display Worksheet2

thank you
--
bmac