Excel: Copy Entire Row

[chriscj21]

Afternoon all;

Hope someone can help me...

I have written a script that searches an Excel spreadsheet, looks for certain criteria and pipes this out to a second spreadsheet. This all works as expected. I now want to pipe out an entire row if certain parameters match.

I am using ".ActiveCell.EntireRow" to select the row, I just have no clue how to copy this out to another spreadsheet.

Up until now I have been using an array for individual column entries of a row. Just seems I can't find a simple way to copy out the whole row (and paste elsewhere.


Any suggestions appreciated



ChrisCj21
MCSE, A+, N+

 

[PHV]

A starting point:
.ActiveCell.EntireRow.Copy

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886