HI everyone, i have 2 sheets that A and B.
I got stuck on insert new row by code as below in other sheet in the same workbook.
So it works on A (which active sheet), but what i need is insert new row in B in case the active sheet is A.Rows(i).Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
I tried to code like "Sheet(B).Select " or "With Sheets(B)" or samething like that, but fails.
Can anyone help me this? Hope the help come soon!!! Thanks in advance!!!