I'd like to know how to fill the following macro down several thousand rows...I found the macro online but when I run it, it only fills the first row...Sorry if this is an obvious question but I'm a noob when it comes to macros....
Please Login or Register to view this content.
Code tags are requird when posting VBA code, per forum rules ( you did read them, right?).
Please edit your post to add the code tags, which are used like so:
After you correct your post, someone will chip in and help.Please Login or Register to view this content.
Last edited by Vaibhav; 02-14-2012 at 07:45 AM. Reason: chking
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
I'm sorry but I don't understand what a code tag is. I copied and pasted the entire code as I found it. I apologize for my ignorance but I really don't know much about macros...Originally Posted by Palmetto
Hi smiso24
To add Code Tags (Rule #3).
To edit your post, go to post #1, press Edit Post, press Go Advanced to see the [#] button). Highlight your code then press the [#] button. Press Save Changes. The result will appear like this in the post window:
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you for the clarification.
You need to describe your workbook (better to post a sample). However, the line Set Rng = Range("A1:C1")
sets the range as three cells A1,B1,C1 ---> the first row.
In order to expand Rng to include all rows you need something like:
Please Login or Register to view this content.
Ben Van Johnson
I've included a sample worksheet. I'd like to concatenate cells B1:D1 and put the result in cell E1 while preserving the color scheme of the individual cells. I actually have roughly 1700 rows of data and would like to do this for each row. Hope I explained it okay...
Works on cells from A1:Cn, putting the concatenated string in column D of the same row
Please Login or Register to view this content.
Last edited by protonLeah; 02-12-2012 at 07:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks