Range("a1").Row
Range("a1").column

NickHK

wrote in message
oups.com...
I'm using a macro to allow a user to design a form, part of the macro
is thus:

sLeft = Selection.Item(1).Address
sRight = Selection.Item(Selection.Count).Address
iTotalcells = Selection.Count
sRange = sLeft + ":" + sRight

What I need to do is work out the x and y coordinates of the upper
left cell that the user is selecting, so "A1" would be x =1 and y =1
while "C6" would be x = 3 and y = 6 and so on.

How can I do that?

Thanks for any assistance.