View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GoKingBee GoKingBee is offline
external usenet poster
 
Posts: 1
Default Create a Named Range in Excel with VBA

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