• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Updating Autofill Series

I

indi visual

Member
Dim C As Range

Range("A2").Select

For Each C In Range("A2", Selection.End(xlDown))

C.Value = ActiveCell.Offset(0, 1).Value & " " & ActiveCell.Offset(0, 2).Value & " " & C.Value

Next C


I'm using this to place the value of B & C in front A.


So it will look like A B C.


This code works; however, because B contains numbers, how do I get those numbers to auto fill down in a series like.


AB1C

AB2C

AB3C etc..


right now they look like this:

AB1C

AB1C

AB1C ..all the same and so forth


In B they're all sequenced properly, but as soon as I merge them over they all return back to 1 all the way down again.


If anyone has a better way to merge text into one column all together I will scrap this idea and go with yours.
 
Resolved!


Nevermind on this one guys, it appears my code was only merging the first line and skipping the rest (and that's why the numbers weren't sequenced).


I was making this way too complicated as always : )


I'm gonna start from scratch headed in this direction.


=concatenate(A2,B2)
 
You must log in or register to reply here.
Back
Top