LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bonnie
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to select multiple text boxes in excel for formatting Rob New Users to Excel 3 April 2nd 23 08:38 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM
Need help on Select Case Susan Hayes Excel Worksheet Functions 1 November 3rd 04 10:25 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"