Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range
I am trying to write the VB code that will name a range (on a shee
called 'Office Staff') according to the value in cell E4 (on a shee called 'Main Menu') all I have of that row of code so far is... Sheets("Office Staff").Range("B2:M15").Name = I have already defined the E4 cell for other functions as: Dim Oname As String Oname = ActiveSheet.Range("E4").Value Can I use this and refer to Oname value somehow?? -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming a range | Excel Discussion (Misc queries) | |||
Range naming | Excel Discussion (Misc queries) | |||
Naming a range | Excel Discussion (Misc queries) | |||
Range naming | Excel Programming | |||
Naming a Range with VB | Excel Programming |