Richard Smit
04-23-2008, 03:46 AM
Hello There,
I'm new to VBA in excel, I would like to identify the values in a range.
Let me explain in detail...
I have a column filled with various values,I need to copy the cells where the date is a future date, any date that is greater than the current date to a different workbook. I've managed to find out the way to copy date to different workbooks. However... I'm stuck when I have to identify if the date is a future date. Please help guys, I'm in urgent need of your help. Thanks.
- Richard
I'm new to VBA in excel, I would like to identify the values in a range.
Let me explain in detail...
I have a column filled with various values,I need to copy the cells where the date is a future date, any date that is greater than the current date to a different workbook. I've managed to find out the way to copy date to different workbooks. However... I'm stuck when I have to identify if the date is a future date. Please help guys, I'm in urgent need of your help. Thanks.
- Richard