C
cornishbloke
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??
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??