Posted to microsoft.public.excel.programming

external usenet poster

Posts: 219

Doesn't work with or without parenthesis?

I'm trying to create a formula to increment a counter. The variable name
contains a variable.
sCt = "A"

If rCell = "16" Then
sCt = rCell.Offset(, 2).Value
"l16" & sCt & "ct" = "l16 " & sCt & "ct" + 1
End If

It's turning red on me. I want it to yield

l16ACt = l16ACt + 1

That is "el sixteen Ay cee tee"

Does anyone know how to enter this?

Thanks!

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
parenthesis	puiuluipui	Excel Discussion (Misc queries)	2	May 27th 08 01:59 PM
Short key for parenthesis - Hot key	Anders	Excel Discussion (Misc queries)	0	December 19th 07 09:09 AM
Parenthesis problem	gmangrove	Charts and Charting in Excel	1	December 21st 06 03:11 AM
WHAT ARE PARENTHESIS IN FORMULAS?	ann	New Users to Excel	2	August 21st 06 10:43 PM
Parenthesis - to use or not to use?	John Coleman	Excel Programming	4	September 13th 04 02:33 PM

All times are GMT +1. The time now is 02:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us