duplicate count and removal - using colour

[mani_singh]

i need to set a macro to be run that will perform the following:

IF Colourbackground = Red copy Row then count and display
IF Row Contains nothing then delete (i.e. truncating)

thanks for your time

Mani

 

[hsk]

see if this helps
http://www.ozgrid.com/forum/showthread.php?p=303118&posted=1#post303118

 

[mani_singh]

thanks thats sorted now!