| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Name to Cell Value
Hi: have a very large workbook with about 200 sheets. Each sheet has a name. I need to copy the sheet name to cell B7 on that sheet for every sheet. Does any one has a code for this? I was tryng to use ActiveSheet.Range("B7").Text = ActiveSheet.Name but I can't get it to work.  -- halem2 ------------------------------------------------------------------------ halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930 View this thread: http://www.excelforum.com/showthread...hreadid=556975 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
![halem2[_73_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
