| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying Relative Addressing
I need to copy, then insert 3 rows containing relative
addressing, but I need to retain the relative addressing content as is, without modifying it (i.e., =Sheet1!A36 nees to remain the same). And I can't use absolute addressing in the from addres. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Modifying Relative Addressing
Dale,
Insert your rows than use code similar to: Range("A15:M17").Formula = Range("A1:M3").Formula -- sb "Dale Cox" wrote in message ... I need to copy, then insert 3 rows containing relative addressing, but I need to retain the relative addressing content as is, without modifying it (i.e., =Sheet1!A36 nees to remain the same). And I can't use absolute addressing in the from addres. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Addressing not working | Excel Worksheet Functions | |||
| what is the difference between relative and absolute addressing | Excel Discussion (Misc queries) | |||
| what is the difference between relative and absolute addressing | Excel Discussion (Misc queries) | |||
| Relative addressing | Excel Worksheet Functions | |||
| Relative Addressing | Excel Discussion (Misc queries) | |||
Linear Mode
