View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
 
Posts: 181
Default Public variable declaration

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?