Set Msomething = Worksheets("Users").Range("A:A").Find(what:=something, LookIn:=xlFormulas)
If Msomething = something then
A = Split(Msomething.address,"$")
'Column as Letter(s) eg AA
CL = A(1)
'Column as Number eg 27
CN = Msomething.Column
'Row as Number
R = A(2)
'Or
R = Msomething.Row
End If
Or you could try
Set Msomething = Worksheets("Users").Range("A:A").Find(what:=something, LookIn:=xlFormulas)
If Msomething = something then
A = Split(Msomething.address,"$")
'Column as Letter(s) eg AA
CL = Split(Msomething.address,"$")(1)
'Column as Number eg 27
CN = Msomething.Column
'Row as Number
R = Msomething.Row
End If
Bookmarks