Hello,
I want this to run this when i hit a button <add in my form. It works great
if the correct worksheet is open, but I don't run the form in this sheet so
again how do I tell it to look on the database worksheet?
'checks how many rows have data in l and copies the formula down in m
Range("m2", Range("l2").End(xlDown)).Offset(1, 1).FillDown

Thanks guys--
Though daily learning, I LOVE EXCEL!
Jennifer