Newbie loop through cells in a column question

Hi,

I am trying to research and learn by trial and error but running into road blocks. Thanks to another member I got the script below working for 1 cell but now I am trying to make it loop through an entire column.

Question 1: Does Range("B1:B") accomplish the same thing as Range("B1:B200") for specifying all the rows in a column?

Question 2: My script below currently only works for the first cell then stops. What is the correct syntax to help it loop through all the rows?

Thank you in advance.

Please Login or Register  to view this content.

How about this.

Please Login or Register  to view this content.

though I don't see what v is supposed to be ?

Thank you both for the help. The looping works but somehow I've lost what the function was supposed to do (my fault I'm sure). I was trying to loop this script from below which looks for a carriage return in a cell and deletes everything after that. So the looping now works but it's no longer removing the extra characters after the carriage return. As you can tell I am very new at this so I must have changed something somehow. The original script does remove the extra characters but the looping one does not. Going to look at it more.

Please Login or Register  to view this content.

@Jadee

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. I have made the change for you today as you are new to the forum. Please observe all forum rules in the future)