| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using offset following an autofilter
I have used the autofilter on one column in my datasheet and i am trying to
select the cell to the right of the first cell in the filtered list. The filter as it appears in code is: Selection.AutoFilter field:=field, Criteria1:="<" I have very little knowledge of VBA and cannot get the offset function to work on this one. Can you tell me what the next line of code should be to select the offset cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
| Chart / Scrollbar / Offset / Autofilter | Charts and Charting in Excel | |||
| Using Offset with Autofilter data | Excel Programming | |||
Threaded Mode
