Naming a range

  • Thread starter Thread starter cornishbloke
  • Start date Start date
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??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming a range in VBA 4
Inserting Values in a Multidimensional Array from Two Different Controls 2
Finding All Range Names on a given sheet 2
Reference is not valid 9
Prompt to enter a macro name? 9
Return selected option from a control 1
File Name changes with dates and Deleting Rows of Zeros 0
Code to remove external references from range names 1

Back
Top