Finding active sheet via Active Cell

  • Hi,


    This happens in a somewhat complex project. At a certain point in time I know what ActiveCell.Address is but I'm not sure what sheet is active.

    I'm sure there must be a better way than using the immediate window .....


    Any ideas ?


    Cheers

    • Best Answer

    Does this help"

    Code
    ActiveCell.Parent.Name

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Yesterday's thank you seems to have gone AWAL.... your reply was spot on. I just need to study this whole OO thing in VBA more.

    Thanks again for your assistance.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!