N.B.: For Code Scroll Down :) Hello Everyone, This is Sachin K here again, Today while at work one of my colleague got into a trouble. He entered a lot of data into a spreadsheet like names of person and data related to their documents in front of their name. Now all of a sudden he needs to insert a numbering bullets in various rows, similar to one can find in MS Word. Oh !!! Its not there !!! I thought I could write a simple VBA code instead and make things easy for him. Here is the situation (Screenshot 1): You have data in row as seen below from Row No. 2 to Row No. 13. You want to insert 1) , 2), 3), ..., etc. in front of each data in the same cells as they are. It easy to put serial in empty cells in front of the data but remember that's not what we want here. Screenshot 1 : The Problem Here is the Solution (Screenshot 2): The VBA Code runs and gives a result as shown in screenshot below Screenshot 2 : The Solution The VBA Code and Form used (Scree...
Coding in VB6 and VBA are my favourite things to do in my free time as well as for few professional situations.