View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hugh Hugh is offline
external usenet poster
 
Posts: 10
Default Highlite filtered items

Howdy,
Have a worksheet for entry, with a macro that copies filtered ranges to
another sheet.

Is there any way to have code to highlite only the cells in the pasted
range that contain the filter criteria?

Example: filter on Column C, 4 rows copied to sheet 2, highlight the 4
cells in Sheet 2, Column C that contain the filter criteria.
Multiple sets get copied, based on different columns being filtered.

Any help is greatly appreciated.