View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default highlight cell text

Dim ColToCheck as range
Dim cl as range,Temp as string

set ColToCheck=range(cells(1,1),cells(1,1).end(xldown) )

for each cl in ColToCheck



-----Original Message-----
I have an excel spreadsheet that I have to update every

month. This
involves laboriously highlighting all text between the

characters "<"
and "" in one particular column. Is it possible to

write a macro
that will make my life easier?! I'm new to this so all

pointers would
be really appreciated.

MTIA

Jim
.