Google Groups

microsoft.public.excel.programming - 4 posts - 2 authors - Last post: Apr 2, 2004

SpecialCells(xlVisible) On Error GoTo 0 If Not arng1 Is Nothing Then Set ...
first visible row in the autofilter use it like frow = FirstRow(activesheet) So
...
http://groups.google.com/g/8077ff07/t/.../d/29c05811e086c3de?hl=en...8...

Help with copy/paste based on criteria

microsoft.public.excel.programming - 3 posts - 3 authors - Last post: Mar 31, 2004

... way would be to use an autofilter to make only the appropriate rows visible,
... SpecialCells(xlVisible) On Error GoTo 0 If Not rng3 Is Nothing Then Set ...
http://groups.google.com/g/8077ff07/t/.../d/3be42bb73a11a82f?hl=en...8...