Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am writing a program with VB .NET that uses the Excel
object library. I tried to get a value from a cell and assign it to a variable: strVar = CStr(Worksheet.Range("A10").Value) But if the cell is empty, the returned value is Nothing. So I modified the code to check for Nothing: With Worksheet strVar = CStr(IIf(.Range("A10").Value = Nothing, "", .Range("A10").Value)) End With However, I kept getting an Error 91. I tried checking the .Text property of the cell, but that always comes back with an empty string if the cell is hidden. Any suggestion on how I accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieving hyperlink from cell | Excel Worksheet Functions | |||
Retrieving a tuple for a cell. | Excel Discussion (Misc queries) | |||
Cell searching and retrieving | Excel Discussion (Misc queries) | |||
Help Retrieving Cell Values | Excel Programming | |||
Retrieving a cell value with a SQL statement | Excel Programming |