The things you ask are very simple to do, but you need to explain yourself better, in your code you want the formula to be put in to D37, you the overwrite D7, so how do you want to place the formula? should it be in column D last unused cell then down for 20 rows?
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote