How to select/unselect range based on variables

**kirba** · 12-10-2009, 10:57 PM

Hi, I'm very new to programming...

Right now I'm writing Excel macros that will sort data in accending order.

From the macro recording I have:

Please Login or Register  to view this content.

However, I want to unselect the rows if the value for first cell of that row (Cells(x,1)) is empty. So that only the row where Range("Ax")<>Empty are selected.

I tried using variables and if... then commands but none worked. Any ideas? Thanks in advance!! =)

**DonkeyOte** · 12-11-2009, 03:36 AM

Not sure I understand... you can't sort non-contiguous ranges simultaneously.

Care to post an example file which illustrates both "before" and desired "after" ?

**kirba** · 12-11-2009, 04:00 AM

Ok I'll be more specific.
Right now my table looks like this when highlighted:
<img src="http://i50.tinypic.com/20sd3pv.jpg">
The white font is invisible when it is unhighlighted. I can't clear out the cells completely because they are in a formula.
Now, if I want to sort out the rows in ascending order according to the LAST column, the forementioned EMPTY rows would come first, but I want them to remain in the bottom of course.
So this is what I'm try to design my macros to do, select the rows and sort them out in ascending order when the values for the A column are NOT empty. Hence leave out the empty rows. However so far my knowledge of VBA is not enough to do so.
Please help me think of any ideas...

Thanks!