On Mon, 25 May 2009 17:03:32 +1200, kirkm wrote:

Thanks very much everyone. Yes, it wasn't very well put,
the question. It was after being passed to a function
where I wanted the column and row values, without the $.

I changed to sending Target.Row in instead of Target.Address,
but Rick has the answer I was seeking...

line = range("$I$3266").Row (or .Column)

Neater and shorter than what I had, or Split (nice command!)

Cheers - Kirk