Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step to next row in a filtered sheet using form
Hi
Hope for some help to the following issue: I have a form that I use to enter/edit information in a excel sheet. This works ok. But somtime I use filters in the sheet, but when the form is still stepping through the filtered (not shown rows). I want it to step only through the filtered list/rows. The code for stepping forward in the form are shown below - any help will be much appriciatied. Private Sub cmdNext_Click() On Error Resume Next ' ignore error for the moment ActiveCell.Offset(1, 0).Activate If Err < 0 Then Err.Clear ' trash the error End If On Error GoTo 0 ' resume normal error trapping If ActiveCell.Value < "" And ActiveCell.Row 4 Then Call Initialize_Form End If End Sub /Steen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
Creating a form in excel to step through scenarios | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |