Code to make a Range of Cells Absolute

I have a macro that automatically fills the range A2:C4 with the values from row 1(A1:C1). The problem is that i want it dynamic so when i delete a row from A2:C4, the row 5 will not be filled with the values from row 1. I want to make the Range A2:C4 absolute.

Please Login or Register  to view this content.

Hi,

Create a dynamic range name say 'MyRange' defined as

Formula:

Please Login or Register  to view this content.

Then in your code use

Please Login or Register  to view this content.

That said this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see.