Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert Rows Problem
cell a7:=IF(B7=0,"",MONTH(C7)&DAY(C7)) when i select b7:h7 and 'insert, shift rows down' the fromula changes in a7 to =IF(B8=0,"",MONTH(C8)&DAY(C8)) How con I do this without a change to a7? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=474178 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
asking again, macro to insert rows | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions | |||
Challenging Charting | Charts and Charting in Excel | |||
Auto Insert of Rows | Excel Worksheet Functions | |||
insert rows | Excel Worksheet Functions |