Thread: Macro to select only cells containing values within named range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Code Numpty Code Numpty is offline
external usenet poster
  
Posts: 94
Default Macro to select only cells containing values within named range
I have data in 5 columns and a maximum of 12 rows. This is a named range.

Rows will always be complete with data in each column but some rows at the
top and/or bottom of the range will contain formulas resulting in no value
("").

I need to be able to select the rows within the named range that result in
values only, in able to paste them as values elsewhere within the spreadsheet.

Is this possible?
Reply With QuoteReply With Quote