View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default "Flipping" a matrix

Do you mean a VBA array or are you talking about cells on the worksheet.

If a VBA array, what are the dimensions.

If using cells, just insert a column, number it 1 to n, sort on that column
Descending, remove the column. ( if using a vba array, you could write it to
the sheet, use the same technique, pick it back up and clear the sheet. )

--
Regards,
Tom Ogilvy


"John Wirt" wrote in message
...
Has anyone seen VBA code for flipping a n array -- that is, moving row 1

to
the last row, row 2 to the next to last row, and so on until row N is the
first row?

Thank you.

John Wirt