Select cells greater than zero

[Wheelman]

Is there a formula or worksheet function that would select cells in a
range that are greater than zero, so the selection can then be copied
and pasted? I would like to use that function to construct a macro that
on command would select the cells in a column with a defined range that
are greater than zero. The cells all have underlying formulas, but many
are blank as the formula is in the form of: If(??=0," ",????)
Thanks.

 

[Mark Rosenkrantz]

Hi;

Why don't you use the Advanced autofilter, to select these cells and copy
them to an new location ??

Mark.

--

 

[Dave Peterson]

You could apply data|filter|autofilter.

Use a custom filter of greater than 0.

Then copy those visible rows to your new location.

And just to add to Mark's response, Debra Dalgleish has some instructions for
using advanced filter at:
http://www.contextures.com/xladvfilter01.html

And for autofilter:
http://www.contextures.com/xlautofilter01.html

If you need help tweaking your recorded macro, post back.