Dear Colleagues,
I have workbook with many sheets. For each sheet, many rows and columns, I need to copy all rows and columns and transpose them then past in a new workbook. The transposed values are to be multiplied by -1. Then I need to copy and transpose the original cells and past them under the negative values. This means that I have symmetrical values (from negative to positive).
I used the following code and it works well for all sheets except sheet1, attached Book1. What happened that it multiplies the cells by -1 and misses the last row, sheet Ouputs1 in Book2. I do not know why and I tried my best. I wondering if you could help me sorting this out?
Thanks for your time.
Nawr
Bookmarks