| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Row without changing formulas
In Row(1), I have some formulas. As an example, "{=MIN(IF($B
$3:B1994,$B$3:B1994))}" is in Cell B1. Row(2) contains some headings. I have code as follows, that copies data from one sheet and inserts into another sheet: ss.Rows("2:" & 2 + dta - 1).Copy ds.Rows(3).Insert Shift:=xlDown This causes the cell starting and ending values in the Row(1) cells to increase by one. I want the Starting value in cell B1 to always be $B$3, but the ending value to increase by one as I insert new data. Can someone explain how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert new colum, without changing information | Excel Worksheet Functions | |||
| Changing the Insert Row / Column Default | Excel Discussion (Misc queries) | |||
| Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
| Automatically insert time without changing. | Excel Discussion (Misc queries) | |||
| how do I insert a row without the formula changing? | Excel Discussion (Misc queries) | |||
Linear Mode
