I have sheet 1 (formatted as table) and sheet 2 (formatted as table). I want to copy the active row from from sheet 1 to sheet 2. I have tried the below and its works well for normal range but not for sheets formatted as table.I have sheet 1 (formatted as table) and sheet 2