DougDodge
asked on
Excel VBA Loop to count and number rows
I am trying to put together some VBA code to number a spreadsheet rows until a change in a date in an adjacent column makes the numbering start over again.
The attached file shows the basics for it....
Looping may not be the way to go, it is slow and tedious..... If someone has a better way I would be more than happy to review....
Row-Count.xlsx
The attached file shows the basics for it....
Looping may not be the way to go, it is slow and tedious..... If someone has a better way I would be more than happy to review....
Row-Count.xlsx
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Spreadsheets
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
7K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
