Selecting a range, and naming it, within a macro

Mar 15th, 2002, 01:27 AM

I have a macro which copies a column of data (variable length) to a certain part of a spreadsheet. I want to select the range and apply a name to it. When I use the Select Current Region option, it is recorded in the macro with the precise cell references, which is no use when running the macro for a list of a different length. Also, it cannot record the keystrokes of holding the tab down and pressing END.
Can anyone help?
Thanks, Andrew

Mar 15th, 2002, 02:52 AM

Try recording the Ctrl-* combination. Alternatively, use the VBA code Activecell.CurrentRegion.Name="Any text"

Marc

Mar 15th, 2002, 03:34 AM

Quote:

On 2002-03-15 01:52, Anonymous wrote:
Try recording the Ctrl-* combination. Alternatively, use the VBA code Activecell.CurrentRegion.Name="Any text"

Marc

Hi Marc
The VBA code worked beautifully. Many thanks.
Incidentally, I didn't understand what you meant by "Try recording the Ctrl-* combination" - something about creating an outline?

Many thanks again
Andrew

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 01:27 AM	#1
Guest Posts: n/a	I have a macro which copies a column of data (variable length) to a certain part of a spreadsheet. I want to select the range and apply a name to it. When I use the Select Current Region option, it is recorded in the macro with the precise cell references, which is no use when running the macro for a list of a different length. Also, it cannot record the keystrokes of holding the tab down and pressing END. Can anyone help? Thanks, Andrew

Mar 15th, 2002, 02:52 AM	#2
Guest Posts: n/a	Try recording the Ctrl-* combination. Alternatively, use the VBA code Activecell.CurrentRegion.Name="Any text" Marc