It does not sound like you are looking for a code solution even though you
posted in a programming newsgroup. If that is the case, then assuming Column
A is your range's first cell's column, select Column A and click
Data/Filter/AutoFilter. You can now deselect the column and then click the
dropdown arrow that appeared in Cell A1... click "(NonBlanks)" from the list
that appears. You can now select the visible rows and copy/paste them
wherever you need them to be copied to. When you are done, just click
Data/Filter/AutoFilter again (you do not have to select the column this
time) to remove the filter and return your worksheet back to "normal".

--
Rick (MVP - Excel)



"Wes_A" wrote in message
...
I need to select from a range of rows - only those having data (formula
result) in the first cell. There will be some rows without data in the
first
cell but they would contain a formula - these shoudl not be selected for
copy.
I want to select and copy all the rows having data in the first cell in
order to paste these rows as values into a separate sheet in another
workbook.
Any suggestion?