You will not be able to define "date" as a range because to Excel date is a Date, as in the date today is...
Try to define it as "tmpDte" or "rngDate" or "dteRng" instead, think of something that means something to you and is also enhancing the ability to read the code in the future
Thanks georgiboy! Ive changed the variable name now! works smooth
Originally Posted by georgiboy
Posting Permissions
Reply With Quote