LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Select range of rows/Columns?

Hello,

How do I put in VB code/ macro to selection a range of data in row or column
where the number of rows is different each time and # of columns is pretty
consistently the same?

Anyway, I pull some raw data (several thousand of rows) each time in a word
pad format, then I got to select all the rows/ columns with data. Here's the
sequences of events that I do manually that I would like to automate with a
macro:
1) put the raw data manually starting in column B row 1.
2) number 1 to ... rows with data (not blank) in column A (for sorting/
resorting purposes). To be deleted later.
3) select only rows with data (starting w/ a date info), then apply a "Text
to Columns" function to seperate the data to different column.
4) delete all the not needed columns after "text to columns".
5) sort all columns with data by column B, then delete all unnecessary rows
6) resort all columns by column A.
7) delete column A


 
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
I cant select rows or columns cp402 Excel Discussion (Misc queries) 0 April 6th 10 08:17 PM
Select different columns within a range Kiran Charts and Charting in Excel 0 March 8th 10 01:22 PM
How select active rows from A to D columns? ldiaz Excel Discussion (Misc queries) 2 October 2nd 08 04:36 PM
How can change range to select active rows instead of :=Range("S10 ldiaz Excel Discussion (Misc queries) 7 August 29th 08 03:52 PM
How do you select two cells in different rows and columns with ou. M.G Excel Discussion (Misc queries) 3 December 17th 04 11:39 PM


All times are GMT +1. The time now is 11:43 PM.

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

About Us

"It's about Microsoft Excel"