| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine macros variable help | Excel Worksheet Functions | |||
| Transfer variable between macros | Excel Programming | |||
| Macros - variable columns | Excel Discussion (Misc queries) | |||
| Dummy variable in macros | Excel Discussion (Misc queries) | |||
| Macros with variable data | Excel Worksheet Functions | |||
![Neil[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
