I am sure this is possible in a macro, but I'm only just learning them

In a workbook I have 2 sheets one containing last months data (lstmnth)
and one containing this months data (thismnth)

On both sheets I wish to compare the ranges C1:L1, C5:L5, O1:X1, O5:x5


All the cell values are numbers,

if the number on lstmnth is this month I wish to insert a shape
MSoDownArrow possibly in the cell in thismnth

if the number on lstmnth is <this month I wish to insert a shape
MSoUpArrow possiblyin the cell in thismnth

So for example lstmnth!C1 is compared to Thismnth!C1 etc if lstmnth!C1
is greater insert a down arrow in cell C1, this needs to repeat for
each pair of cells in each of the ranges above. So repeated for D1 on
each sheet then E1 on each sheet etc


the shapes need to be transparent and centred horizontally and
verically in each cell.

If the macro could first delete any shapes already on the sheet that
would also be great

thanks in advance for your help


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=493445