Having problems with the range!

[ARowbot]

Hi,

I have been trying to expand a bit of code that was written for me to copy a selection of cells from another sheet onto the end.

I wanted to expand it so that it auto filled the date (weekdays) into the new cells also.

However I am having problems with the range for the autofill...

Please Login or Register  to view this content.

My hope is to generalise the above code using "Previous row, Lastrow and Newrow"

Thanks for any help!!

[soberguy]

Your range reference in red needs to refer to a worksheet first.

[stnkynts]

Please Login or Register  to view this content.

[ARowbot]

Ok, I have done that...Ideally the bit I want to change is:

Please Login or Register  to view this content.

to make it:

Please Login or Register  to view this content.

I am having trouble uploading an attachment at the moment...I am trying!

[ARowbot]

I've managed to play around a bit and done it quite cheekily I think...
Here is the code for anybody interested...

Please Login or Register  to view this content.

Thanks for the help!!