How to highlight and entire column and make the macro perform on each cell ?

Ok so i have this code that when the user puts the active cell in a certain cell and runs the macro, the string data beside the active cells will merge in one cell. So if i have the active cell in A1, and B1 contains the string "Apple" and B2 contains "Orange" and B3 contains "Lemon" when i run the macro, B4 will contain "Apple,Orange,Lemon"

here is the code:

Please Login or Register  to view this content.

End Sub

my problem is that when i reach around 1000 rows, it would be tiresome for me to run each macro on Cell A1 up to cell A1000. Is there a way where i can just highlight the entire cell A1 up to cell a1000 and make the above macro run in the respective way?

Please Login or Register  to view this content.

brilliant!

you are welcome. If satisffied please mark your post as SOLVED