Excel VBA-use variable in active cell formula problem
The comparison was intended to show both approaches produced the same
result.
I was just adding some other techniques to deal with building strings. So
no one can lose. <g
--
Regards,
Tom Ogilvy
"Frank Kabel" wrote in message
...
Tom Ogilvy wrote:
or for comparison:
? "=RC[-1]&""/""" & "&RC[" & i & "]"
=RC[-1]&"/"&RC[10]
? "=RC[-1]" & chr(38) & chr(34) & "/" & chr (34) & chr(38) & "RC[" &
i & "]" =RC[-1]&"/"&RC[10]
Hi Tom
I lost the comparison :-)
best regards
Frank
|