Returning a variable from a sub

Posted to microsoft.public.excel.programming

melisfreed[_6_] melisfreed[_6_] is offline

external usenet poster

Posts: 1

Returning a variable from a sub

hello there! Is there a way to either return a value from a sub to b
used in another sub OR is there a way to call a value from another sub
My sample code below:

Sub Small()
TestPoint = 100
End Sub

Sub Large()
Dim TestPoint

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
Runtime Error '91' Object variable or With block variable not set	Alec Coliver	Excel Discussion (Misc queries)	2	October 24th 09 02:29 PM
GetOpenFilename not returning a usable variable	Lilivati	Excel Discussion (Misc queries)	2	June 26th 06 09:02 PM
variable height variable width stacked bar charts	ambthiru	Charts and Charting in Excel	3	January 18th 06 11:41 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM

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

Menu

About Us