A solution to make every cell in a range always have the same formula?

I 'm trying to make a workbook where for example, sheet2 column b from cell 2:300 will always have a formula in it, all with identical formula's

What I want is lets say someone inserts a row into row 250, the cell wont just be pushed down so that the new cell is now blank, and that the 301 now has the formula in it when it was blank before.

so lets say, the formula is '=2' , cells B2:B300 will always contain the formula, '=2' no matter if I delete or add cells, cells B2:B300 will never hold any other data besides '=2'

Originally Posted by realniceguy5000

Hi,

Place this in sheet2

.

Please Login or Register  to view this content.

This looks good, however, what if I want to do the formula so that it ='Sheet1' + whatever row I'm currently using in on sheet 2 to reference sheet 1

so in row7 ='sheet1'!B7
row8 ='sheet1'B8

and so on and so forth, however, I can it done hard coded as with the programming code given, all I need now is the answer to get it to change in each row

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I hope the correction is better

maybe without loop ?

Please Login or Register  to view this content.

Best Regards
MaczaQ