Thread: When
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default When

Hi Kirk.

MyRow=Target.Row
MyCol=Target.Column

Hopes this helps.

---
Per

"kirkm" skrev i meddelelsen
...
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