Problem with calling another macro (Error 450 and " Expected variable or procedure")

Hello! i'm quite new to vba programming and i've ran in to a problem i can't solve on my own.
It might be one of the simplest problems ever but i would love some help.

There are 2 macros, on is supposted to paste todays date and then call the other macro
which is supposed to copy two cells and paste them in cells XY+1 and then clear the work area.

This is the first macro:

---

Please Login or Register  to view this content.

and the second one is:

---

Please Login or Register  to view this content.

I hope someone could come up with something to help me and
I hope i'll learn something from it.

Have a nice day!!

I suspect the problem is that Cells is a reserved word. Calling your first subroutine Cells will confuse Excel/VBA. And then you have white instead of while.


Regards, TMS

Hi Roxner,

I believe you have a typo in your code

Please Login or Register  to view this content.

This works through, though there are better ways to get to the next empty cell.

Please Login or Register  to view this content.

Regards, TMS