VBA code question

[peyman]

hi,
How can I limit this code Worksheets("sheet 1").ShowAllData to some specific
columns like B & C istead of unfiltering whole the worksheet.
Thanx,

 

[Jim Cone]

Cells.AutoFilter Field:=2
--
Jim Cone
Portland, Oregon USA

"peyman"
<[email protected]>
wrote in message
hi,
How can I limit this code Worksheets("sheet 1").ShowAllData to some specific
columns like B & C istead of unfiltering whole the worksheet.
Thanx,

 

[Don Guillett]

Just recorded

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 2/4/2009 by Donald B. Guillett
'

'
Selection.AutoFilter Field:=3
Selection.AutoFilter Field:=2
End Sub

 

[peyman]

thank you very much

Just recorded

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 2/4/2009 by Donald B. Guillett
'

'
Selection.AutoFilter Field:=3
Selection.AutoFilter Field:=2
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[peyman]

thax a lot

 

[FSt1]

hi
i doubt that you can. technically excels "filters" by hiding rows. and it's
not possible to hide or unhide part of a row (or column).

Regards
FSt1