Copying Rows to clipboard from a range if they have values

Hello Excel Forum,

I have a constant range of cells ("A8:Q530") that are populated from another worksheet. I have a button that when clicked I would like to select and then copy the rows that aren't blank to the clipboard. The number of rows that get populated are different each time but remain within the range above. After scouting the web for a few hours I found this...

Dim RangeSelect As Range

Set RangeSelect = Range("A8:Q8")
    With RangeSelect
    Range(Selection, Selection.End(xlDown)).Select
    End With
RangeSelect.Copy

(All the cells in the range contain IF formulas that return Blank or with a value.)

However this only appears to select the first row (A8:Q8). Any help would be very much appreciated as I've only been using VBA for a week now.

Thanks,

MikeDC

If the cells contain formulas, using End(xldown) will select them all even if your syntax is fixed. You must loop - either through each cell or only through one column if there will always be data for one of the columns if there will be any data for that row?