ExcelBanter - Date Variable in Macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date Variable in Macros (https://www.excelbanter.com/excel-programming/443520-date-variable-macros.html)

Neil[_29_]

Date Variable in Macros

Hi,

I currently have a macro that copies data from 1 worksheet to another.

What i would like the macro to do, is only copy and paste the data if
the current day is not a Sunday or Monday.

Any help would be greatly appreciated.

Thanks
Neil

Jim Cone[_2_]

Date Variable in Macros

Checkout the VBA WeekDay function.

--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL

..
..
..

"Neil"
wrote in message
...
Hi,

I currently have a macro that copies data from 1 worksheet to another.

What i would like the macro to do, is only copy and paste the data if
the current day is not a Sunday or Monday.
Any help would be greatly appreciated.
Thanks
Neil

All times are GMT +1. The time now is 03:40 PM.