Macro to select only cells containing values within named range

C

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
VBA set thick borders around non empty cells in range 0
Select rows with visible data 0
Range passed to a function - trying to just move through the range 4
Select a specific row in named range 7
copy named range & paste 2
How to check and select within hidden cells only 1
Need Excel Macro to select an unknown, named table and convert it toa range 1

Top