Two-part question here:
How can I insert a row at the top of a list such that the named range doesn't shift down by one row. Effectively, I have a set of data from A3:J20 and a named range beginning in A3. When I insert a new row on top of line 3, the named range obviously shifts down by one row, and the array formula I have which references the named range no longer evaluates the contents in A3. Is there a way to resolve this? I know I can insert a row in row 4, copy the contents in cell 3 down to 4, and enter the new data into row 3, but this method is ineffecient.
Also, it would be greatly appreciated if someone could provide a script that would allow for a message box to appear that prompts the user to provide the number of new rows to be added. So, if I wanted to add 10 new rows--only between columns A and J (shift cells down)--how can this be accomplished?
Many thanks
How can I insert a row at the top of a list such that the named range doesn't shift down by one row. Effectively, I have a set of data from A3:J20 and a named range beginning in A3. When I insert a new row on top of line 3, the named range obviously shifts down by one row, and the array formula I have which references the named range no longer evaluates the contents in A3. Is there a way to resolve this? I know I can insert a row in row 4, copy the contents in cell 3 down to 4, and enter the new data into row 3, but this method is ineffecient.
Also, it would be greatly appreciated if someone could provide a script that would allow for a message box to appear that prompts the user to provide the number of new rows to be added. So, if I wanted to add 10 new rows--only between columns A and J (shift cells down)--how can this be accomplished?
Many thanks