Posted to microsoft.public.excel.programming

Mike H.

external usenet poster

Posts: 471

Concatenate a Const Name in Sub Routine

Could you not just say:

If counter=1 then
left=10.1
elseif counter=2 then
left=20.1
....etc

or just
left=(counter*10)+.1

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
Const Fails to work	johnb	Excel Programming	5	May 22nd 07 03:23 AM
Const Array	SÃ¶ren_MarodÃ¶ren	Excel Programming	3	January 25th 07 01:09 PM
Not recognizing a Const	Dan T[_3_]	Excel Programming	7	July 18th 04 12:45 AM
Public Const on a Drive	MD	Excel Programming	1	July 15th 04 03:53 PM
crash changing const to public const	BrianB	Excel Programming	0	August 4th 03 10:13 AM

All times are GMT +1. The time now is 04:52 PM.

About Us

"It's about Microsoft Excel"