Hi,
I have a formula in sheet Email that could either return blank or has a value. Range of cells are from T:AE depends and number of rows depends. Then i need to copy those non blanks cells to "screenshot" sheet which already contain the headers from email. so i'll be pasting it to cell a2. then i would sort Column L to descending. My problem is that when i run the code, the whole row moves to say L43 instead to the cell under the headers
Bookmarks