VBA finding a cell based on the value of a pivot table

paeddi

New Member
Joined
Aug 17, 2019
Messages
7
Thank you, I'm using German version of Professional plus 2016 Version 1907

I get the message: address = 'Mastertabelle Einzel'!S2:S67

Kind regards to Mexiko (btw, my wife is mexican)
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,159
Office Version
2007
Platform
Windows
What is the range of cells in sheet " Mastertabelle Einzel" where you have your data?

Saludos a la paisana de México!
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,159
Office Version
2007
Platform
Windows
Forget the above, try the following:
Select a data in the pivot table and run the macro.

Code:
Sub finding_cell()
    Dim f As Range, wItem As String
    wItem = ActiveCell.Value
    If wItem = "" Then Exit Sub
    Sheets("Mastertabelle Einzel").Select
    Set f = Cells.Find(wItem, , xlValues, xlWhole)
    If Not f Is Nothing Then
      f.Select
    End If
End Sub
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,159
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,282
Messages
5,485,855
Members
407,521
Latest member
marita

This Week's Hot Topics

Top