Range("E1:e" & i).Formula = "=$A$" & i - 1 & " - " & "$B$" & i - 1 ' *Does
work*
On Fri, Feb 25, 2011 at 4:47 AM, Nasim wrote:
> Hi,
>
> I am trying to enter the folowing formula in cells but whatever I do I
> can not make the "-" part work and it just enters a dash in the cell:
> i tries chr(34
Hi,
I am trying to enter the folowing formula in cells but whatever I do I
can not make the "-" part work and it just enters a dash in the cell:
i tries chr(34) & "-" & chr(34) and it did not work either.
I need range(E2)= $A$1 & " - " & $B$1
.Range("E" & i).Formula = "=$A$" & (i - 1) & " & " &
