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) |