Macro to select only cells containing values within named range

[Code Numpty]

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?

 

[royUK]

Maybe, change MyRange to your range name


Code
-------------------
Range("MyRange").SpecialCells(xlCellTypeConstants
-------------------

--
royU

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com

 

[Code Numpty]

Thanks Roy I was able to use that and get exactly what I need.