i= myVar.Row
j = myVar.Column

this assumes myVar is a range variable

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DaveyJones" wrote in message
...
I'm trying to find some code that will return the row number of a variable
'Val' as 'j' and the column as 'i'.

For example

Call A1

i=1, j=1

I've tried the row command but i'm not having much luck... Any help
appreciated.


--
Dave