What is the code for "Ctrl-Select" rows?

[castout]

I need to loop through rows and select the row based on the value in a column. Basically, I want to "ctrl-select" each row that meets my criteria. I tried recording the macro, but it just looked like this:

Range("5:5,12:12,15:15").Select

Anyone know how to do this?

Thanks!

 

[PHV]

Why not applying a filter and playing with xlCellTypeVisible ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886