End Down

[aresquare1]

If my cursor is on a cell in the top left corner of a matrix and I want to move down this column to the bottom, (End Down), then copy this bottom row of data in this matrix that is 6 columns wide to the row below it, what is the code for that.

Thanks for your help,
RR

[AB33]

In which column is the matrix, you could try one of these lines?

Please Login or Register  to view this content.

[aresquare1]

The top left corner of the matrix sits on a cell named "WC_Table". The table currently has 6 columns wide and 2 rows tall. So what I'm trying to do when the macro runs is to make the range 6 columns wide and 3 rows tall by copying the bottom row to the row directly below it. Hopefully that makes my situation a bit clearer.

Thanks again,
RR

[AB33]

If this code does not work, please attach a sample with your desired result.

Please Login or Register  to view this content.