Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sheet named “Summary” contains a range name “TempNumber”.
I need a macro that will, within the current sheet, go to cell A1. It will look at the range TempNumber and name the range (of cell A1) a combination of the word “Vehicle” plus the value in TempNumber. Example: The value in range TempNumber is "Test1". This macro will cause Cell A1 of whatever the current sheet is to be named “Vehicle Test1” This will be used in different sheets, so I need it to do this in whatever the Current Sheet is. Thanks j.o. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating columns based on date range | Excel Worksheet Functions | |||
creating columns based on date range | Excel Programming | |||
Creating a range name based on cell content not being a negative value. | Excel Programming | |||
suggestions on creating a text value based on a date range | Setting up and Configuration of Excel | |||
Creating recordsets based on a range | Excel Programming |