Posted to microsoft.public.excel.programming

Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline

external usenet poster

Posts: 201

Public/Procedure Variable

Excel 2003, WinXP
I have a called sub:
Sub Test(TheCell as Range)
End Sub

This declares TheCell as a procedure variable. I want to declare TheCell as
a Public variable. If I declare TheCell As Range as Public at the top of
the module, how do I write the "Sub" line of this macro? Thanks for your
help. Otto

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
Set Public Variable on Open	jlclyde	Excel Discussion (Misc queries)	4	September 11th 09 07:03 PM
Public variable	Jack	New Users to Excel	4	March 18th 06 09:35 PM
Declaring Public Procedure	mac	Excel Programming	3	December 3rd 03 05:01 PM
Scope of Public Variable	Dkline[_2_]	Excel Programming	9	October 22nd 03 04:53 PM
public variable	marwan hefnawy	Excel Programming	1	September 5th 03 08:54 AM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us