View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
peyman peyman is offline
external usenet poster
 
Posts: 189
Default 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,