If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Merging Cells
Yep. Starting points for instructions can be difficult to pinpoint. I used to
joke to my co-workers that I really don't want to tell them how to set their alarm clocks and get ready for work--much less document their path to work--or how to find the on/off switch on the pc. But I read Gord's instructions and they seemed quite reasonable to me bg. If I were you, I'd revisit his instructions and try it once more. If you have questions, post back with the steps you followed (which could be difficult to document vbg). You may find that Gord's function useful later--or you may find that you need something different that can't be done in MSWord. Just a thought (or two). David wrote: I tried it that way, I honestly did. Then reverted to including content that should, clearly, have been replaced. I entered the phrase 'A2:A150' and also A2,A150' just to be sure. But, whilst the help and advice of experts such as yourselves is greatly appreciated, do understand that it's sometimes easy to forget just what degree of detail is needed in describing how to do someting. I've been an IT trainer and do have some experience of this. Imagine telling someone how to drive a car, who's never seen one before...how would you describe changing gear? In terms of a gearstick? Of second and fourth etc? What's a gear?? Anyway, I got there in the end. And to my mind, it's a shame that Excel has so much trouble doing something so simple. Concatenating data in cells. Word can do it! Thanks for all your interest. -- David Kitching Msc. Msc. Managing Director Natural Deco Ltd. The Manor Manor Lane Loxley Warwickshire CV35 9JX UK. Tel: +44 (0) 1789 470040 Mob: +44 (0) 7799 118518 www.naturaldeco.co.uk "Pete_UK" wrote in message ups.com... Too late, Gord, he's already done it using Word. Anyway, Dave told him that yesterday. Pete Gord Dibben wrote: David There is no exclamation mark in my code. I think that when you copied the code you also copied the Usage instructions. Just copy the part from Function ConCatRange(CellBlock As Range) As String down to and including End Function Gord On Fri, 1 Sep 2006 09:33:51 +0100, "David" wrote: Many thanks for this. But I keep getting the message'Compile Error: Expected: list seperator or )' and the exclamation mark in the code becomes highlighted. David Gord Dibben MS Excel MVP -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|