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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"GoKingBee" schrieb im
Newsbeitrag ...
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

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

"GoKingBee" wrote:

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