Solved

Numbering columns in autofilter

Posted on 2013-01-20
2
181 Views
Last Modified: 2013-01-20
Guys, Please see the attached file;

Is it possible to number rows with a formula that takes into consideration a file is in autofilter and not in autofilter?

Thank you for your help,
Robert
next-row.xlsm
0
Comment
Question by:rws1
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 38798914
Try

Private Sub ot_Click()
Application.Calculation = xlManual
    Range("H4:H40").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Criteria1:=1
    Rows("4:4").Select
    Selection.EntireRow.Hidden = True
    Application.Calculation = xlAutomatic
    With Sheet1.AutoFilter.Range.Offset(, -5).SpecialCells(xlCellTypeVisible)
        .Cells(1) = "=max(r1c:r[-1]c)+1"
        Debug.Print .Cells(1).Address
        .FillDown
        .Offset(, 6).Cells(1).Select
    End With
End Sub
0
 

Author Comment

by:rws1
ID: 38799159
Works great, thank you very much
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now