VBA macro code to add a column named serial number and fill in that column till n where n is number of count of items in the adjacent column.

[pjayant]

Hi All,

I want to design a vba macro code for the snap attached. The number of rows will be dynamic. Please suggest.

Regards,
Jayant

 

[Marc L]

Hi,​

​

you may use the ROW worksheet function for the serial # …​

​

 

[pjayant]

Hi Marc, can you please help me with the vba code.

 

[AlanSidman]

crossposted: https://www.mrexcel.com/board/threa...-in-the-adjacent-column.1143407/#post-5541619

 

[vletm]

pjayant
You really should reread Forum Rules as soon as possible

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

You seems to missed many things.
Those are for You too.