View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete[_25_] Pete[_25_] is offline
external usenet poster
 
Posts: 16
Default Select a range not equal to:

Want to use VBA to select and copy a range that includes only the cells not
returning: "".

The formulas in the cells/range evaluated either calculate and return a value, or return a "" (from the formula)
The cells returning "" are always at the bottom of the range, while the cells returning data are on top.

Just want to highlight the results so as to copy them into another application.

TIA for any ideas.

Pete