| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing a string array for any values
Guess I should.
"Tom Ogilvy" wrote in message ... since he said: I have a dynamic, zero-based, string array guess you should have stated it more directly. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Spot on Dave. It assumes variant (there was an implicit giveaway in my comment that it would fail if there are strings or numbers :-)). Bob -- HTH RP (remove nothere from the email address if mailing direct) "Dave Peterson" wrote in message ... I don't think this will work with string arrays: Dim myArray() As String ReDim myArray(1 To 5) MsgBox Application.CountA(myArray) I got 5 back in the msgbox. Bob Phillips wrote: Chris, You could try If Application.CountA(ary) 0 Then 'process it End If it will fail if there are strings or numbers. -- HTH RP (remove nothere from the email address if mailing direct) "Chris W." wrote in message ... Hi, I have a dynamic, zero-based, string array that I Redim often, and i want to know how do i test it to see if it actually has any elements in it before I put it thru the loop to extract the data. If I have no elements I want to exit before looping. Can I use IsEmpty to test a string Array or is it a "" value by default. I forget, and documentation is sparse on details. thank you -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Testing of an array | Excel Worksheet Functions | |||
| Testing same cell across multiple sheets for a string and counting each instance? | Excel Worksheet Functions | |||
| Passing a String in Array to Range as String | Excel Programming | |||
| Fill an Array with String values | Excel Programming | |||
| Variant Array with String Values - Type Mismatch | Excel Programming | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
