ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Row without changing formulas (https://www.excelbanter.com/excel-programming/440088-insert-row-without-changing-formulas.html)

iamnu

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?


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com