Thread: highlight non blank cells in column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default highlight non blank cells in column
Hi Annette

See also the VBA help for specialcells for the other Types

On Error Resume Next
Columns("A").Cells.SpecialCells(xlCellTypeConstant s).Select
On Error GoTo 0



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Annette" wrote in message ...
how do I programmically highlight only those cells in a column that contain
data?




Reply With QuoteReply With Quote