Jeff

Posts: n/a

VBA defining variables

Hi

I have the code below. I set JJ=33, and I need Macro5 and Macro6 to use the
variable JJ. But when it goes into those macros JJ is empty. Do you know
how to fix this?

Sub TestMacro2()
Dim JJ As Double
JJ = 33
Call Macro5
Call Macro6
End Sub

Thanks for your help

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
How do I use variables in Excel?	XUT67	Excel Discussion (Misc queries)	1	October 3rd 05 07:11 PM
How do I use variables in Excel?	XUT67	Excel Discussion (Misc queries)	4	July 22nd 05 09:04 PM
solver and defining all variables different than one another	excel_excel_excel	Excel Discussion (Misc queries)	0	July 19th 05 07:38 AM
Plot 2 variables on Y axis	nemme	Charts and Charting in Excel	1	March 18th 05 08:17 PM
Index Match With 3 Variables	Scooterdog	Excel Worksheet Functions	5	January 2nd 05 07:05 PM

All times are GMT +1. The time now is 02:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us