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