Thread: In a Macro replacing $x with ($x + i) gives x+1 not $x+1 as expe.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
zorro
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote