Dynamic Range + error message

Been working on the following macro:

Formula:

Please Login or Register  to view this content.

Although I've come across two problems which I can't quite solve:

1. The "311" part of the range needs to be dependant on whether there's a data point after that value (i.e. dynamic).

2. As the macro is working, it'll post that a column is being overwritten. This needs to be automatically approved - instead of me clicking "yes" every time

Solutions to the following problems would be massively appreciated

Ty
Mdn

Is the "Text to columns" part of your code meant to overwrite the Selection ID column?

BSB

Originally Posted by CK76

1. To make range dynamic.

Please Login or Register  to view this content.

I'm a bit of a novice when it comes to VBA, but replacing the "range" with the code gives me a couple of errors. What did I do wrong?

Please Login or Register  to view this content.

Something like below?

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

BSB

You are welcome and thanks for the rep