Your question is not entirely clear. What do you mean when you say "pass
Target.Address"... do you mean pass that into another subroutine or
function? Or did you mean pass the String value $I$3466 into another
subroutine or function? Or did you mean as macropod indicated... working
with the Target argument of an event procedure within the event procedure.
Either of the first two can be done by using the address as an argument to
the Range object and then querying it for the row and column. For example,
assuming Arg is the name of the argument in the subroutine or function that
you are passing either Target.Address or "$I$3466" into...

MsgBox "Column: " & Range(Arg).Column & vbCrLf & "Row: " & Range(Arg).Row

--
Rick (MVP - Excel)


"kirkm" wrote in message ...
When you pass Target.Address as a parameter e.g $I$3466
is there a system command to get the row and column from that?
(I know it's dead easy to DIY but just wondering).

Thanks - Kirk