VBA code question
 

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,

VBA code question
 

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

"peyman"

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,

VBA code question
 

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

"peyman" 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,

VBA code question
 

thank you very much

"Don Guillett" wrote:

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

"peyman" 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,

VBA code question
 

thax a lot

"Jim Cone" wrote:

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

"peyman"

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,

VBA code question
 

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

"peyman" wrote:

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,