Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range
I posted this in a different form before. I appreciated the replies,
but they didnt work for me. I will post this hoping that someone can help me with this version of the problem. ActiveSheet.Range("A1").Select ActiveCell.Offset(0, 1).Range("A1").Select What Im looking for is to be able to name a range in the following manner after the 2 lines above. The range name will be the word Junk plus the value of the range name TempNumber EXAMPLE: if the value of TempNumber is XXX, then the new range name will be JunkXXX Thanks for your help, jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming a range | Excel Discussion (Misc queries) | |||
Naming a Range...? | Excel Programming | |||
naming a range | Excel Programming | |||
VB Code Naming a Range (range changes each time) | Excel Programming | |||
Naming a range | Excel Programming |