When retrieving values from webtable into an array. If there are blank lines within the webtable those values are also being stored into the array. How would I avoid doing that?
use this function
"I realize it's an error, but no one is going to try to do that!"
From "Top 10 Stupid Comments from Developers".
For intRow = intFirstDataRow to intRowCount
If Trim(objTable.GetCellData(intRow, intCol17))<>""
ReDim Preserve arrCol17(UBound(arrCol17)+1)
arrCol17(UBound(arrCol17)) = objTable.GetCellData(intRow, intCol17)
works fine. Thanks.