I have a macro (part of a larger project) to do some actions based on dates in col A and S .
see attachment is empty test 1.xls
the objectives -
1) scan thru rows and check if values in col A and S are blank
2) if blank (or 1/1/1990) then copy prev row to current row in place of blanks.
3) if not "do nothing".
4) To avoid copying qty field which in real case, will have value and prevent overwriting qty field I split ranges to R1 R2 (buy side) R1 and R2 (sell side) section of data, excluding qty field.
5) The message boxes are added as test.
6) I use named ranges to define ranges. please check these
7) values in col AW1 and AX1 show the total no of rows to be processed in Buy and sell section resp.
However though cols a and s are in date format it keeps showing the values 00:00:00 when i execute macro in break mode and hence the excel does not work the way I designed. Please review and make suggestions
see attachment is empty test 1.xls
the objectives -
1) scan thru rows and check if values in col A and S are blank
2) if blank (or 1/1/1990) then copy prev row to current row in place of blanks.
3) if not "do nothing".
4) To avoid copying qty field which in real case, will have value and prevent overwriting qty field I split ranges to R1 R2 (buy side) R1 and R2 (sell side) section of data, excluding qty field.
5) The message boxes are added as test.
6) I use named ranges to define ranges. please check these
7) values in col AW1 and AX1 show the total no of rows to be processed in Buy and sell section resp.
However though cols a and s are in date format it keeps showing the values 00:00:00 when i execute macro in break mode and hence the excel does not work the way I designed. Please review and make suggestions
Last edited: