Thread: Macro Copy Worksheet Name into worksheet A1
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Macro Copy Worksheet Name into worksheet A1
Hi bmac

You can use a worksheet function if you want ?
http://www.xldynamic.com/source/xld.xlFAQ0002.html

If you want code post back

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"bmac" wrote in message ...
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
Reply With QuoteReply With Quote