Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vb code question | Excel Discussion (Misc queries) | |||
vb code question | Excel Discussion (Misc queries) | |||
Another code question | Excel Discussion (Misc queries) | |||
VB Code Question | Excel Discussion (Misc queries) | |||
VBA code question | Excel Discussion (Misc queries) |