shg - sorry but an error has come to light.
The problem is, ALL cells in column F containing formulas are being
acted on.
I only want those cells containing the bottom-most formula in each
series acted upon.
If you see macro2, this does what I want except that it doesn't
transfer the format over.
Your code seems to do what macro1 does.
Is there a way to get macro2 to cut/paste formats along with the
formulas??
Big thanks.
Colwyn.


+-------------------------------------------------------------------+
|Filename: example 2.xls |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=14|
+-------------------------------------------------------------------+

--
colwyn
------------------------------------------------------------------------
colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30569