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 "Like" 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 "Like" 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!

Register Yourself Login