| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the active cell in an Excel formula | Excel Worksheet Functions | |||
| Set a variable to the active cell | Excel Discussion (Misc queries) | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| value of active cell into a variable | Excel Programming | |||
| Problem with Active Cell Refence | Excel Programming | |||
Hybrid Mode
