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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using offset following an autofilter
For Each c In Selection
If Rows(c.Row).Hidden = False Then If iCt = 0 Then iCt = 1 Else c.Offset(0, 1).Select Exit For End If End If Next c Add this after what you have. Using iCt avoids the header row. Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using offset following an autofilter
That worked a treat.
Cheers Merjet. Do you know of any good online excel vba training? "merjet" wrote: For Each c In Selection If Rows(c.Row).Hidden = False Then If iCt = 0 Then iCt = 1 Else c.Offset(0, 1).Select Exit For End If End If Next c Add this after what you have. Using iCt avoids the header row. Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using offset following an autofilter
Do a Google search for: excel vba tutorial online
You will find plenty. I can't say how good any of them are from personal experience. Hth, Merjet |
Reply |
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 |