Thread: Parent child relation between two rows in an excel sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Parent child relation between two rows in an excel sheet
or maybe that you mean "merger range"
if A1:A3 are a merger range
SecondRow = Range("A1").Item(2).Row
the SecondRow's return value will be 2



--
isabelle

Reply With QuoteReply With Quote