Relative cell reference in formula with vba

[ramakavin]

Good Morning everybody,

Here is my problem (Im a vba newbie!)

Please Login or Register  to view this content.

I have this code which essentially takes the formula from B6 and copies it in the next empty row.

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

[shg]

Maybe ...

Please Login or Register  to view this content.

[ramakavin]

Hello SHG,

As usual, u are the quickest to reply! I am sure your code works as i managed to generate something similar with the macro recorder. However, i am not managing to integrate it to my code. I followed a tutorial to create a userform and it uses the structure i posted above. i.e with the offset and row count.

I duno how to modify this code to achieve what i am looking for. Maybe i will just post my excel file so you can have a clearer idea. Thank you very much for your help