Selecting cells returned after using autofilter

[colinharwood]

Hi

Is it possible to write a Macro which will select only the rows with data in, after using autofilter, so that they may be copied to another worksheet.

Thanks a lot
Colin

 

[kskinne]

The code:

Selection.SpecialCells(xlCellTypeAllValidation).Select

Should work for you to select your validated cells

HTH
kevin

 

[colinharwood]

I tried that but got an error message saying "No cells found"

Any ideas

Colin

 

[kskinne]

I gave you the wrong syntax - AllValidation wouldn't work for you in your case.

what kind of information do the cells that you are autofiltering contain?

 

[colinharwood]

Some contain text some numbers and some formulas

Cheers

Colin

 

[Aladin Akyurek]

On 2002-08-29 15:03, colinharwood wrote:
Some contain text some numbers and some formulas

Cheers

Colin

You could also try Advanced Filter that allows you copy/filter to another location in even another worksheet.

 

[Juan Pablo González]

Something like this:

Cells.SpecialCells(xlCellTypeVisible).Select