Fnd out order(decending) of selected range.

Closed
Nilot - Mar 1, 2009 at 07:41 AM
kikikiss Posts 8 Registration date Tuesday October 21, 2008 Status Member Last seen May 15, 2009 - Mar 2, 2009 at 06:31 AM
Hello,

Hi, I am a begainer in excel/VBA. I have values like:

APP date 02-02 01-29 01-29 01-14 01-06 01-06 12-29
DUE date 02-09 00-00 00-00 01-09 00-00 00-00 12-09
TYPE 172 745 745 173 745 745 173
AMOUNT 1,097.75 55.00- 55 1,097.75 39 86.00 0

Now I need to count the APP date till empty cell, then need to count # of 173 values in TYPE row. If the # of 173 is more then 1 then I need to determine whether the DUE date values are in descending order or not. If yes then in another sheet i need to enter YES in c4 cell.

Please help me in this....

1 response

kikikiss Posts 8 Registration date Tuesday October 21, 2008 Status Member Last seen May 15, 2009
Mar 2, 2009 at 06:31 AM
hi,
try this link where you will get a pdf file. download it, this is a guide for visual basic users:
dl.extensis.com/downloads/PF/EN/P/Portfolio8_VisualBasic_Guide.pdf
it may be helpful to you.
0