Macro to select only cells containing values within named range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Code Numpty <CodeNumpty@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 24 Nov 2008 04:06:05 -0800

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 spread***.

Is this possible?
.

Follow-Ups:
- Re: Macro to select only cells containing values within named range
  - From: royUK

Prev by Date: RE: Special sum of texts
Next by Date: RE: my incomplete macro to fill in 8000 rows - pls help
Previous by thread: change pivot table in code
Next by thread: Re: Macro to select only cells containing values within named range
Index(es):
- Date
- Thread