Relative cells in macro - and pasting a formula too!
Andy,
You're welcome. Cross-posting can only result in unnecessary effort - most of these groups are
monitored by the same people anyway, which is why I saw your cross-post. But if I hadn't seen it and
didn't reply to it, someone might have done so later, when seeing an un-answered post, not knowing
that I had answered your question here.
Bernie
MS Excel MVP
Thanks very much! That's sorted it. Much appreciated.
I did apologise for posting the question twice, by the way! Sorry again.
|