Hot to read all cell value from Excel using visual basic

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • suresh_punniyakkodi
    New Member
    • Aug 2006
    • 20

    Hot to read all cell value from Excel using visual basic

    Hellow Friends,
    I have one doubt, please help me...
    In Excel, i have lot of rows and coloumns, i need to read all cell values with in rows and coloumn limit...
    At the time of read data from excel, Invalid use of Null error came...
    In that current cell have an '#VALUE!" -> that means illegal value...
    I need to read same '#VALUE!"(exact cell value from excel)...
    #VALUE! -> means, formula error... But, i need to read '#VALUE!' from excel...
    Please help me...

    Regards,
    Suresh...
Working...