Forum Discussion
Autofill numeration in row until last empty cell
Hi, How can I create macro which can autofill numeration in row. It have to end this macro at the end of this table. I was trying to make it in this way: It worked perfect, but in empty sheet. I...
Thank you for help.
I copy and paste your code but it's not working.
I don't get ant error when I starting your code but it will do nothing.
Which Excel version do you have?...operating system, storage medium?
Does the inserted file work for you?
Does the inserted file work for you?
- https://drive.google.com/file/d/1kHRWKOA6HPGdMwsHp9Hb1QBISxLJw6ER/view?usp=sharing
Please check in my exampleAttached is the example in the file.
If I may recommend that you use the formula in your projects, I think it will be of more use to you.
Example with formula you will find in column "J".
When you write something in column K, the numbering appears as desired.
Its great idea and off course it working.
But I sometimes adding more rows belowe table. When I adding row the formula is not copying.
Thats why I would like to use VBA.
Thank you