Hi
I'm trying to use a vba to insert a row, and copy dynamic formulas from above.
I have problem with formulas like "=SUM($F$9:F12)". The new row get the same formula, but should get "=SUM($F$9:F13)".
My vba code is like this:
' Q4 is input to define which row to insert new.
Dim verdi As Variant
verdi = Range("Q4").Value
Rows(verdi).Select
' Copy formula from cell above
Rows(Selection.Row - 1).Copy
Rows(Selection.Row).Insert Shift:=xlDown
End Sub
Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post
All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.
How to use code tags
Note: no apostrophe in the tags, just used for demonstration here.
['code]
your code goes between these tags
['/code]
Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.
Thanks.
Thanks. I tried to edit my post to fix the Code, but cant find where to start editing my recent post.
The sheet with this code, have several ranges with different headlines, so it is unfortunately not suitable for a Table.
You can have multiple tables on one sheet, and I would say that that fact alone makes Tables the better option.
Also, attach an example workbook.
Don’t have an account yet? Register yourself now and be a part of our community!