Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty function in VSTO
In Excel VBA, there is a function which will tell you if a cell is empty, e.g.
IsEmpty(ActiveCell) but I can't find that function in VSTO. How would I determine if a certain cell in Excel is empty using VB in VSTO? (I'm using VS 2008 and Excel 2007). -- Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty function in VSTO
Try
If Rng.Formula.Length=0 Then where Rng is the reference to the cell. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Ed White" wrote in message ... In Excel VBA, there is a function which will tell you if a cell is empty, e.g. IsEmpty(ActiveCell) but I can't find that function in VSTO. How would I determine if a certain cell in Excel is empty using VB in VSTO? (I'm using VS 2008 and Excel 2007). -- Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty function in VSTO
I'll try that. I also tried
If String.IsNullOrEmpty(Rng.Text) = True and it seems to work (it's important to use .Text and not .Value). -- Ed "Chip Pearson" wrote: Try If Rng.Formula.Length=0 Then where Rng is the reference to the cell. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Ed White" wrote in message ... In Excel VBA, there is a function which will tell you if a cell is empty, e.g. IsEmpty(ActiveCell) but I can't find that function in VSTO. How would I determine if a certain cell in Excel is empty using VB in VSTO? (I'm using VS 2008 and Excel 2007). -- Ed |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty function in VSTO
Hello Ed,
In fact, "IsEmpty" is a VB6 (or VBA) stuff. It's not a part of the Excel object model or function, instead, it's exposed by the VB6 class library. In VB 6, the Empty keyword indicates an uninitialized variable, and the Null keyword is used to indicate that a variable contains no valid data. VB ..NET does not support either keyword, but uses the Nothing keyword in both of these cases. http://www.ondotnet.com/pub/a/dotnet...ex.html?page=4 In addition, the IsEmpty function is not supported in VB .NET, and C#. That's why we cannot find it in a VSTO project. In .NET, we use IsNothing() / IsDbNull / String.IsNullOrEmpty as you have found out. Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: . ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Implement Excel cell function using VSTO | Excel Programming | |||
where to place undo-function in vsto-projects? | Excel Programming | |||
Function with VSTO ? | Excel Programming | |||
vba: isempty | Excel Programming | |||
Problem with IsEmpty Function | Excel Programming |