Select until character

**hazzaska** · 02-09-2021, 10:14 AM

Hi

Could someone help in tweaking my macro, Currently it selects "a1 to x7" and runs which if fine unless my data has less lines, The data i have always finishes with an hyphen on the row below the data i require to copy. I need my macro to select the range upto and including the first instance of the hyphen if thats possible.

Any help greatly appreciated

Works

A1 02/09/2021
A2 02/09/2021
A3 02/09/2021
A4 02/09/2021
A5 02/09/2021
A6 02/09/2021
A7 -

Doesn't work

A1 02/09/2021
A2 02/09/2021
A3 02/09/2021
A4 02/09/2021
A5 -

A1 02/09/2021
A2 02/09/2021
A3 02/09/2021
A4 02/09/2021
A5 02/09/2021
A6 02/09/2021
A7 -

Please Login or Register  to view this content.

**6StringJazzer** · 02-09-2021, 10:25 AM

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 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. No help to be offered until this moderation request has been fulfilled.)

**hazzaska** · 02-09-2021, 11:38 AM

Originally Posted by 6StringJazzer

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 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. No help to be offered until this moderation request has been fulfilled.)

Sorry about that all i have edited as requested.

Thanks

H

**alansidman** · 02-09-2021, 03:20 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)