How to select D35-U51

[Bonnie]

Hi there, using 02 on XP.

What is the best way to highlight/select a set area?
Macro? Code? I have a spreadsheet with data listed in 3
stacked tiers. Want to move it so it flows in one tier
across for export. Tier 2 data is located in grid area D35-
U51. Do I place cursor in D35 and create a macro that
selects however many columns to the right and then how
many rows down? Then is it best to create a button to run
the macro? I'll be getting a spreadsheet once a month.
Will I need to import the macro/code to that file?

Thanks in advance for any help or advice.

 

[Peo Sjoblom]

It might be easier just to type in the range in the name box (above A1)
D35:U51
then press enter

 

[Bonnie]

By jove, Peo, that works great. Sometimes I try to make
things too difficult. I really appreciate the prompt
response. Now on to my next step.