Change a date in a macro to a cell reference

[ClaireH]

Hello,
I have just started trying to use macros and have built one which copies and pastes data from one sheet to another sheet, based on certain criteria.
One of these criteria is the month - at the moment this is a fixed date but I need this to be a cell reference. Then, when you update the cell reference to a different value, the data which is returned will change.
The macro is as below:

Please Login or Register  to view this content.

And it's the '7/1/2013' I want to be able to change to a cell reference. Help much appreciated, thanks!

[StephenR]

Claire - please add code tags as per forum rules.

[:) Sixthsense :)]

Try this - Untested code

Please Login or Register  to view this content.

[ClaireH]

Hello,

No....that didn't work :-(

I got an error saying 'compile error - Statement invalid outside Type block'.

Any clue?

[:) Sixthsense :)]

Oopss... try this...

Refer it to your range

Please Login or Register  to view this content.