Good Morning everybody,
Here is my problem (Im a vba newbie!)
I have this code which essentially takes the formula from B6 and copies it in the next empty row.Please Login or Register to view this content.
Cell B6 contains the following formula : =AND(E6>=StartDate;E6<=EndDate)
However, when i run my macro, it copies the same formula from cell B6 without regards to the destination cell, which is relative as entries are made.
For example, cell E43 will contain the =AND(E6>=StartDate;E6<=EndDate) instead of =AND(E43>=StartDate;E43<=EndDate)
Could you guys help me figure out how to make it copie the formula but adjust it to the destination cell please? I am using excel 2000 and only a beginner at vba!
thanks in advance
Bookmarks