Hi all,
i have tried to insert multiple rows on 2 sheets at the same time with inputbox, but can't get it to work. I have tried to array the 2 sheets before the code, but it only inserts the rows on the active sheet.
I can get it to work on 1 sheet. My code look like this when i insert multiple rows on 1 sheet:
This code works whits 1 row, but i need to insert multiple rows.Please Login or Register to view this content.
Please Login or Register to view this content.
How do i modify the code so it inserts multiple rows the same place in 2 sheets, and copy the formula down.
The sheets af called "Tilbudsliste" and "Aconto, kontraktarb."
The reason for the code is that i have locked the cells that contains formula.
I hope it makes sence.
Bookmarks