What is a good way to loop through data when the keyword to end the loop may vary? See the example below. Thanks in advance for any help.
If activecell.value =“order” then
Line = “ “
Line = line & activecell.value
Loop until ????
The keyword will depend upon what the user entered into the order form. If a field such as donation is not entered, then it will not show up on the form. When I started coding, the form had the keyword “donation” but the next form used “address”.