Message box to display range of cells. Solved, thanks

[henrysmith]

Hi,

I am using the following code to display a range of cells from a single column (A1:A10) in a message box, with each cell value on a seperate line.

Please Login or Register  to view this content.

My question is; how do I make it work so that it will display the value of cells from a row, ie A1:J1 ?

Thanks.

[MickG]

Hi, The "Join" Function Specifies a One Dimensional Array.
I think you would need something like the code below to achieve your Requirement.

Please Login or Register  to view this content.

Regards Mick

[pike]

or even

Please Login or Register  to view this content.

[jrdnoland]

Numerous ways to do it, here's another:

Please Login or Register  to view this content.

[DonkeyOte]

henrysmith, welcome to the board... please note:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please edit your initial post in line with the above.


For ref. use Join method as outlined - try to avoid iteration where possible

To convert a horizontal vector to a single dimension array transpose the array twice over, eg:

Please Login or Register  to view this content.

[MickG]

If only I'd read the Question !!!
Here are some options:-

Please Login or Register  to view this content.

Regards Mick

[henrysmith]

Thanks for all the replies,

I have gone with donkeyotes, despite the mild rebuke

....how the hell do I update this message to "solved"?

[DonkeyOte]

see FAQ / How To but in general to quote the stock response:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save