Thread: Complex search and replace macro based on input variables.
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
  
Posts: 465
Default Complex search and replace macro based on input variables.
In article , Claus Busch
writes
Hi Colin,

Am Tue, 15 Jul 2014 14:46:40 +0100 schrieb Colin Hayes:

c.Offset(, ACol - SCol).Font.ColorIndex = arrClrs(Range("XFD1").Value)

do you work with xl2003 or older?
Change "XFD1" to "IV1"


Regards
Claus B.

Hi Claus

Yes , I have 2003 here.

OK all good now - thanks again



Best Wishes









Reply With QuoteReply With Quote