Forum Discussion
vba table valid row count
Hi, I'm supplied Word documents that contain a table that has differing valid rows therefore I need a variable to count the valid rows. In Excel this would be something like: Sub Test()
Wi...
Use
Dim objSS As InlineShape
With ActiveDocument.InlineShapes(1)
.OLEFormat.DoVerb wdOLEVerbHide
With .OLEFormat.Object.Application
With .workbooks(1).Worksheets(1)
MsgBox .Range("A1").currentregion.Rows.Count
End With
End With
End With- Thanks for that response.
I tried running and go the error message 'the requested member of the collection does not exist'
The table is there and editable so any ideas why it errors?
TIAa_bonsey Is a line of the code highlighted when it fails?
This is the result of running the code here
