Create a Named Range in Excel with VBA

[Guest]

Hello Group:
I am attempting to create a named range in Excel by using a VBA macro. I
have a table of information where the number of rows is variable. I need to
create a hard coded range name by running a macro which will change as the
number of rows changes.

I attempted to record keystrokes, but am not getting the correct result.
Does anyone have any code they could share in this case?
thx
Bill

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Names.html

 

[Guest]

If your table already has a range name (in my example "mytable"), then try
this piece of code

range("mytable").currentregion.name="mytable"

If the range doesn't exist yet, you need to add statements to set the active
cell to one within the range of interest, then continue with this code:

activecell.currentregion.name="mytable"

Substitue your named range as needed.

Rick Ward