clear contents of range

Why doesn't this code work?

Please Login or Register  to view this content.

But this code works:

Please Login or Register  to view this content.

Thanks.

Also, if I do have to use the bottom code, is there a way of "unselecting" the range after it's been cleared? Without then selecting A1...

Please Login or Register  to view this content.

Should also work as long as you have data in Column A of sheet "DO"

What the line does: Select rows 4, column 1 up to last row and column 145. I suspect the the last row -"r" does not go down the way you wanted it because you may not have data in Colulmn A of sheet "DO".
Could you check what is the last data entry in sheet "DO" Column "A"?

Hi -

Put .address

Please Login or Register  to view this content.

Regards,
Event

I tried the code on a different range just incase "r" was messing it up....

Please Login or Register  to view this content.

Run time error!
I really don't know why it's not working

Yay that fixed it (.Address)!
Thanks so much