locked
excel sheet named ranges RRS feed

  • Question

  • How to get the first row index of a named range in excel sheet from vb.net code...

    for example I set the column 1 of row 2 to column 5 of row 4 a range named it "MYRange" ( it is set from excel sheet )

     

    now I want to get the starting position means 2 from my vb.net code

     

    Thanks 

    Wednesday, September 8, 2010 6:52 AM

Answers

  • Try this way..

      For Each rCell In Range("rnge")
        Debug.Print rCell.Address & " : " & rCell
        MsgBox rCell.Column
      Next rCell
    
    • Marked as answer by Martin_Xie Sunday, September 19, 2010 7:54 AM
    Wednesday, September 8, 2010 7:08 AM