VBA finding a cell based on the value of a pivot table
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

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

  1. #11
    New Member
    Join Date
    Aug 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA finding a cell based on the value of a pivot table

    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)

  2. #12
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,669
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: VBA finding a cell based on the value of a pivot table

    What is the range of cells in sheet " Mastertabelle Einzel" where you have your data?

    Saludos a la paisana de México!
    Regards Dante Amor

  3. #13
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,669
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: VBA finding a cell based on the value of a pivot table

    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
    Regards Dante Amor

  4. #14
    New Member
    Join Date
    Aug 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA finding a cell based on the value of a pivot table

    Cool, works as required, thank you so much!

  5. #15
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,669
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: VBA finding a cell based on the value of a pivot table

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •