Hello.
I have two exactly the same sheets, but one in my national language, and one in English. I've made a macro that adds a row under ActiveCell and pastes the formulas needed there.
The problem i have - it doesnt affect the English sheet. And i need it mirrored... Absolutely no idea how to do it! Could you please help me?
Here's the code i use. It's pretty strange, because i had to work around some problems (xldown wouldnt bring me to the last cell)
The real problem is... Excel doesnt know where to begin in the Second sheet. It doesnt mirror the ActiveCell address from first sheet, and i have no idea how to tell him this...ActiveCell.Offset(1, 0).EntireRow.Insert
Range(ActiveCell.Offset(0, 1), ActiveCell.Offset(0, 5)).Copy
ActiveCell.Offset(1, 1).PasteSpecial (xlPasteFormulas)
Application.CutCopyMode = False
ActiveCell.Offset(0, -1).Select
Thanks!