| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding cell info to rename sheet(s)?
If sh.Cells(1, 1).Value = " " Then sh.Name = "MEANS"
The above looks for a space in A1. If it's an empty cell you're checking for do this: If sh.Cells(1, 1).Value = "" Then sh.Name = "MEANS" -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| Rename Sheet using Cell Reference | Excel Worksheet Functions | |||
| Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
| Macro to rename all worksheets with cell value in each sheet | Excel Programming | |||
Threaded Mode
