Absolutely right. The order in the worksheet is Column, Row, (in the A1 Reference style; not in the R1C1 reference style) and in
all VBA functions it is Row, Column.
I don't even feel dumb anymore is I confuse them once more!

--
Kind regards,

Niek Otten

"Bob Phillips" wrote in message ...
| Well in that case you want Niek's alternative solution, but you will still
| get M5 with those variable values, not E13. If i is row it should be 13 not
| 5!
|
| --
| HTH
|
| Bob Phillips
|
| (remove xxx from email address if mailing direct)
|
| wrote in message
| oups.com...
| i think i have not put it correctly. I do not want to assign "a" to
| E13, rather i want to assign the string E13 which is obtained through
| i=13, j=5 (i and j are variables) to a variable called 'a'.
|
|
|