VBa code for autofill column

[Maxy]

Hi forum members,

I need help to create a code that can fill up a column.

For example my data is from A2:A600, i need a pop up message that ask me "how much" and when i enter a number , it will fill the number in B2:B600 ( the end of the data will be varies everytime )

Thanks in advance

[JOHN H. DAVIS]

Welcome to the Forum Maxy. Does this help?

Please Login or Register  to view this content.

[Maxy]

Hi John,

Thank you so much, works like a charm , really appreciate it man , Star for you :D

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.