macro help for a beginner

[Danz]

I have got the above macro set up and it is workiing great, thanks. Jus
one more question, if i want to run this macro on 2 different coloumns
for eg coloumn A and B) what would i have to change in the code? (i wa
thinking it must be in the part where you specify the range). Th
functin can be the same, so basically want to duplicate the macro t
run in 2 coloumns on the same sheet, thanks again in advance

 

[Nick Hodge]

Danz

On my code just change the columns ("A:A") to ("A:B").

Danz: Not aimed at you.... How much do I hate replies from these forums
mirroring the MS newsgroups? They don't show replies in a standard fashion
and never include any of the original messages. Does anyone have a channel
to the people who run these or is it just me? Maybe too it's the way MS is
handling them, but it's starting to get really annoying!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)