How do I select multible non-contiguous rows by criteria?

[ECF1956]

I have a spreadsheet that has 8 columns with data fields in columns. I want to select the rows in VBA that have a null value in the 5th column. I then want to copy them. Can anyone help?

 

[Tazguy37]

How about:

Range("E:E").SpecialCells(xlCellTypeBlanks).EntireRow.Copy

Just change the range to the column you're looking at. HTH

 

[ECF1956]

This does not solve the problem

I need to select more than one non-contiguous row when Column 5 is blank.

 

[ECF1956]

Is this possible?

 

[Tazguy37]

ADVERTISEMENT

So what results are you getting?

 

[ECF1956]

Thanks

TAZ your code worked - But it also copies all rows after those that have data. What is the best way to filter those out?

 

[Tazguy37]

I see why. You could do it this way:

Range("E1:E" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Copy

so it looks at Column A to find the last row of data. You could also use Autofilter or Advanced Filter.

 

[ECF1956]

Thanks ever so much

I am a novice in VBA programming. The help you guys give me makes my life so much easier. I had the autofilter solution but your code is much cleaner. Thanks.