| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Editing a simple macro | Excel Worksheet Functions | |||
| macro with F9 | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
