VBA to filter only visible results of advanced filter

[csh8428]

I know there are TONS of posts like this, but I have not yet been able to implement one of them that I can get to work. Its probably because I'm a complete noob at VBA though.

I have an advanced filtered data set that dynamically changes in row size and goes to column N that is on Sheet "EE_SS_OOBS" that I need to copy ONLY the visible results to sheet EE_SS_OOBS2.

I have tried a lot of iterations from various other posts, but can't get any of them to work.

Could somebody please give me the code to get it to work?

Thanks,

Craig

 

[James006]

Hi,

Have a try with :

[SIZE=3][COLOR=#000000][FONT=TIMES NEW ROMAN]ActiveSheet.UsedRange.Offset(1, 0).SpecialCells (xlCellTypeVisible).Copy[/FONT][/COLOR][/SIZE]

HTH

 

[csh8428]

Hi,

Have a try with :

[SIZE=3][COLOR=#000000][FONT=TIMES NEW ROMAN]ActiveSheet.UsedRange.Offset(1, 0).SpecialCells (xlCellTypeVisible).Copy[/FONT][/COLOR][/SIZE]

HTH

How do I paste it?

 

[James006]

How do I paste it?

You are welcome