Insert Row without changing formulas

I

iamnu

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Cumulative formula for word table 0
Insert Row also adds formulas and moves cursor 2
Document Merge Formatting Issue 0
Conditional Formating: MAX & MIN 3
Copy columns and paste with blank column between 5
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 1
Keeping formulas on an insert 1

Top