How to select D35-U51
 

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.

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

--

Regards,

Peo Sjoblom

"Bonnie" wrote in message
...
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.

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.

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

--

Regards,

Peo Sjoblom

"Bonnie" wrote in
message
...
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.


.