Date Variable in Macros

's Computer Specifications

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

's Computer Specifications

Checkout the VBA WeekDay function.

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

..
..
..

"Neil" <(E-Mail Removed)>
wrote in message
news:ad7ea48c-de25-444c-ba97-(E-Mail Removed)...
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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine macros variable help	Ephraim	Microsoft Excel Worksheet Functions	2	21st Mar 2010 01:52 PM
Transfer variable between macros	WLMPilot	Microsoft Excel Programming	4	8th Oct 2009 05:58 PM
Macros - variable columns	Evan	Microsoft Excel Misc	1	14th Aug 2009 05:51 PM
Converting macros: Object variable or With block variable not set	=?Utf-8?B?Sm9lIEtyYW1lcg==?=	Microsoft Access Macros	1	14th Jul 2005 09:48 PM
Re: How to pass variable value between macros	BCS	Microsoft Excel Programming	0	25th Jul 2003 08:01 PM