Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
How can I highlight only some of the text within a cell in Excel? | Excel Discussion (Misc queries) | |||
highlight cell contain the value and text with formula | Excel Discussion (Misc queries) | |||
How do I highlight text only within a cell in Xcel? | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |