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
.
|