Good evening Angol

Can you select the range(s) that need to be worked on? If so, use a
for next loop thus:

For Each Rnge in Selection

' Your code goes here, but replace the cell address with Rnge

Next Rnge

When the range(s) is / are selected, this code will perform any given
operation on each selected cell in turn.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386928