Posted to microsoft.public.excel.programming

Alberto Ast[_2_] Alberto Ast[_2_] is offline

external usenet poster

Posts: 181

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
public variable declaration, memory efficient?	slarbie	Excel Programming	2	April 6th 09 03:56 PM
Use of Public for data declaration in Excel 2000	Gandalph	Excel Programming	1	April 17th 08 06:47 PM
Declaration of public variable - Question	Les Stout[_2_]	Excel Programming	2	October 5th 05 02:53 PM
Public declaration	Greg[_16_]	Excel Programming	2	January 21st 05 10:53 PM
public declaration	kevin	Excel Programming	1	December 6th 03 07:00 PM

All times are GMT +1. The time now is 07:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us