Autofill only Available Lines

Hello,

Anyone know how to stop an autofill in a macro? For example I have data in columns A - H and a formula in I1, J1 and K1
I have a macro that autofills the formulas down but I would like it to stop when there is no more data in columns A and B. The idea is users will paste info into A-H but the number of lines of data can vary between users

Here is the single code I have so far:

Please Login or Register  to view this content.

Thanks so much

Thank you so much!! That did the trick