I have a Word requirements document that I want to parse and place just the
requirements numbers in an Excel spreadsheet. The requirements numbers
all have the format (Fnnnn) where the n's are numbers. An example would be (F0010)
They are not in any numerical order. I might have (F0010)...
I have a spreadsheet which I am parsing with VBA to create another spreadsheet with the information in another format.
How do I know how many rows there are in the source spreadsheet and how do I know when I have finished reading all of the rows?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.