Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have code that runs an AutoFilter, on a six column
dataset in column A thru F. I use the following code to try select a part of the result. With .AutoFilter.Range .Offset(0, 1).Resize(.Rows.Count - 0). _ SpecialCells(xlVisible).Select End With This will start the select in Column B but then runs it out thru column G (a blank) Question: Is there a way to just select column B,C, & D? Thanks. -Randy- .. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl | Excel Worksheet Functions | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) |