RichMaru

When I use Wait for Key Press for the simple purpose of letting the user "signal" that the macro is to proceed, I use a key such as Ctrl, which has no effect on the application when pressed and released.

Yes, that would allow me to address any particular cell, but it requires me to declare an array variable for every possible column - a royal pain. And how would you write a loop structure to step through all cells in a (2-dimensional) range? You'd have to have a separate loop for every column (A, B, C...).

Rich

There are lots of times when I wish MEP would allow more than one dimension for a variable array. A simple example would be when I'm trying to store the contents of a spreadsheet. I could use one dimension for the row, and the other for the column. That way I could refer to an array element as, say, T[5,4]. As far as I know, this is not possible.

Does anyone have a way to deal with this limitation? I've thought about using an array where the elements are other arrays, but I haven't figured out how to make that work. A 2-dimensional array would be so much easier.

Any ideas?

Rich