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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - In a Macro replacing $x with ($x + i) gives x+1 not $x+1 as expe. (https://www.excelbanter.com/new-users-excel/75023-macro-replacing-%24x-%24x-i-gives-x-1-not-%24x-1-expe.html)

zorro

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

$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.

All times are GMT +1. The time now is 06:07 AM.