View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randal W. Hozeski Randal W. Hozeski is offline
external usenet poster
 
Posts: 33
Default Selecting Range After AutoFilter

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-

..