Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA for Word recognizes zeros in table rows as Null
Skip you are the BEST !!! Thank You very much! I was amazed yesterday with your extemely fast and accurate reply. I'm sorry it took 24 hours for me to reply but I had to tweak a couple of things and then throughly test it this morning and viola! I works great. Thanks for solving this vexing...- VBAword
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA for Word recognizes zeros in table rows as Null
That works, I get zero, but how do I fit Left(.Text, Len(.Text) - 2) into sNodeValue = rngTable.Cell(iRow, iColumn).Range.Text would it be something like sNodeValue = rngTable.Cell(Left(.Text, Len(.Text) - 2)) ??- VBAword
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA for Word recognizes zeros in table rows as Null
When I am cycling through the cells in a table the variable in the code below (sNodeValue) doesn't pick up anything when there is a zero in the table cell in MS Word. The variable is declared as String. Numbers and letters are recognized fine, but zeros shows up as "". sNodeValue =...- VBAword
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
