View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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