more info would help.

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Joy Chen" wrote in message
...
Hi,

I like to write a micro that will select a range of cells
based on a starting point/cell that I assign each time
and perform repetitive data sorting for me from there.
Any help would be appreciated. Thank you.

Joy

I have segments of data in my spreadsheet that contain similar
information and require to be organized in the similar fashion. It
would be nice if I can write a macro so that each time I can sort a
fixed size of range starting at the beginning of each segment. Thank
you.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The way that works for me, which may not be the BEST way is: For the other
ranges I want to loop through, I select the starting cell of the following
ranges, in code, one at a time: Example Range("A1").select. This would then
make it the active cell . I would then loop down the range and perform
whatever action I wanted.....
"Joy Chen" wrote in message
...
I have segments of data in my spreadsheet that contain similar
information and require to be organized in the similar fashion. It
would be nice if I can write a macro so that each time I can sort a
fixed size of range starting at the beginning of each segment. Thank
you.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!