Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Worksheet Names
What is the code to paste the worksheet name in cell "C3" of each worksheet
in the workbook? I tried the following, but it didn't work. Thank you. Sub insertname() Dim Rng As Range Dim n As Integer Dim y as integer n = Worksheets.Count For y = 1 To n Worksheets(y).Select Set Rng = Range("A1") Range("A1").Select ActiveCell.Offset(0, 3).Value = Sheet.Name Next y end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Insert Worksheet Names into Cells | Excel Discussion (Misc queries) | |||
Selecting ALL names when using Insert/Names/Apply | Excel Worksheet Functions | |||
I need a macro that will insert names in an excel worksheet, the . | Excel Programming | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming |