Incrementing rows in VB is of cause easy as they are numbered but how
can I increment columns as they are alphabetical?
Even if I change to R1C1 reference style, how can I relate to a cell?
Normally the reference Sheets("Sheet1").Range("A1").Select is OK
but in R1C1 format, cell "A1" becomes "R1C1". VB dos'nt seem to
recognise this.
What do I put in the same command instead of ""A1"?


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=484299