jaango123
11-26-2010, 04:47 AM
Hi all,
please help me with the below two queries
1)How to find programmatically, no of rows which is not blank. Can I useUsedrange.rows.count. If so do you have any examples.
2) I have three macros. macro1,macro2,macro3
Can anyone help me in writting another macro which will
1)execute macro1
2)Sort the data in sheet1 according to column H
3)Remove all the rows which has column H blank
4)execute macro2
5)sort by column T largest to smallest
6)remove all the rows which is having Column T below 14
7)Sort by Column A add one more level and sort by column G
8)execute macro 3
Any help is appreciated
please help me with the below two queries
1)How to find programmatically, no of rows which is not blank. Can I useUsedrange.rows.count. If so do you have any examples.
2) I have three macros. macro1,macro2,macro3
Can anyone help me in writting another macro which will
1)execute macro1
2)Sort the data in sheet1 according to column H
3)Remove all the rows which has column H blank
4)execute macro2
5)sort by column T largest to smallest
6)remove all the rows which is having Column T below 14
7)Sort by Column A add one more level and sort by column G
8)execute macro 3
Any help is appreciated