To store a cell reference, it might be best to put it into a
variable, such as:
actsheet = ActiveSheet.Name
actcel = ActiveCell.Address
Or, you might use a variable to show which sheet it refers to such
as:
actcelsh2 = ActiveCell.Address
Without any further information, I don't think I can tell what you
want to use that information for, so it would help if you would
explain what you want to do with it.
The other thing to consider is what is going to trigger the VBA
macro? . . . a sheet level event? . . . or something else?
If you tell us what you are trying to do with that information, it
might help to answer your question.