In a Macro replacing $x with ($x + i) gives x+1 not $x+1 as expe.

[zorro]

$x eg $10 can be replaced normally by $11 but when used with the counter i
( i=i+1) 11 is returned and can be replaced seperately to $11.
This occurs whether the cell is formatted as number or general. The $ is
being used to create an absolute cell adress not a currency.