Public variable declaration
ActiveCell.Address is a string.
So:
Public xlast As String
If you used:
Set xlast = ActiveCell
Then
Public xlast As Range would be correct
"Alberto Ast" wrote in message
...
I tried first searching on the discussion group already place questions but
could not find what I need.
I have a variable I use to store a cell address
xlast = ActiveCell.Address
I am trying to declare it as public so I can use it in other modules but I
have fail several ways... what I have is
Global xlast As Range
Is the Range type correct? or how should I do?
|