View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Bhandar[_2_] Neil Bhandar[_2_] is offline
external usenet poster
 
Posts: 8
Default Need to identify the start and end of range

Hello:

I have a RefEdit field with the range 'TaxData'!
$B$4:$G$18', I need to figure out the StartRow, StartCol,
EndRow, EndCol reference.

e.g. $B$4 = Row 4, Col 2
$G$18 = Row 18, 7

is there a VBA function that could return the Row/Col
values directly or if some one can point me to a piece of
code I can reuse.

Thanks in advance,
-Neil