I'm currently using the following code to concatenate several cells into one cell, but it also displays the cells that contain blanks.
So I tried using the following code I found, but I'm getting an error.
Please Login or Register to view this content.
I'm new to coding in VBA, so any help would be greatly appreciated.Please Login or Register to view this content.
Last edited by ewellis; 11-24-2008 at 02:51 PM.
Do you have the MOREFUNC xll installed?
Yes, I have that installed.
Try this:
If you're only going to run it on your machine (or if it's for work and MOREFUNC is in the standard build) then what Bob is going to come up with may be easier ... if not, the above will do the job.Please Login or Register to view this content.
Hope that helps.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
MatrixMan
How would a go about using this code. After I place it as a module in excel what exactly would I enter in my actual cell. I'm new to coding in VBA and I'm confused on what to do.
Never mind. I figured out how to use it. Thank you for all your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks