writing an AND formula in VBA

what would the code look like to link all values in column S starting with S2 with all values in R starting in R2 and dump them consecutively into column AF starting with AF2? i know i could write a non-VBA formula in cell AF2 of =S2&R2, but the sheet this is going into clears out the previous data every time a main macro is run and i don't feel like typing the formula in new every time. i tried to record the code to see what it would look like and then manually write it into my 'mother macro' but it didn't work.

not tested:

Please Login or Register  to view this content.

Your do loop should look something like this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Feel free to test the code and adjust it to your needs.
e.g.

Please Login or Register  to view this content.

Please do not judge a suggestion you didn't test.

I quanified the range to let function the code.
When using 'evaluate' in bracketform [...] you have to quantify. You can take the range very large as a safety margin, because if nothing is in column R the result will be an empty cell: "".
You asked for a dense code, this is one.

Sometimes it's a matter of taste, sometimes it's a matter of speed:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

You are the one to tell....

What's your expected number of rows ?

I think the fastest method is:
(if A1 is not empty)

Please Login or Register  to view this content.

Originally Posted by juniperjacobs

but i'm trying to understand why you quantified the range?

You should resist taking the codes we suggest at face value and attempt to use them as is or post back here instead of diving in and pulling it apart for yourself. We expect you to analyze them, understand them, then change them to suit your needs.

...if anything shouldn't it go to the end of the sheet?

I would suggest that this is usually a bad idea. Putting formula through an entire sheet for the convenience of it probably asking for problems at some point.