Hi klunker,
It won't work as you posted it, however, if you take the .Value = .Value out of the With statement, the macro will paste the formula into the workbook, and this will adjust itself for the relative address. Then outside the with statement, select the range and convert it back to values.
Again, I haven't properly tested this, but it should work!
Regards,
David
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Bookmarks