Hey guys
I did play with the named range quite a bit.
I saw how inserting a row with a named range will work with formulas and that is great to know,
still I am using a lot of VBA in this spread sheet.
I have this bit of code in the worksheet calculate event
Private Sub Worksheet_Calculate()
'Extra Cash Cells in Row 5 = Extra Cash Cells in Row 127
Range("C5").Value = Range("C127")
Range("D5").Value = Range("D127")
Range("E5").Value = Range("E127")
Range("F5").Value = Range("F127")
Range("G5").Value = Range("G127")
Well, even with a named range, inserting rows etc., it still will not pick up the change.
So, if you inserted a row a 127, then the cell C5 will become blank.
I am open to suggestions but I still believe that this will involve some dynamic coding of some sort
Thank you
Mark