Hello,
I am trying to take the number that appears in the cell Range(B1:C1) and have it used in a string. B1:C1 is a merged cell that I cannot change in the sheet. Eventually I want to use the string as the subject line of an email, but for this time I am having it appear in a message box.
Please Login or Register to view this content.
Last edited by erice; 02-07-2018 at 01:11 PM.
If you want the cell content, you can just use
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Or ..
Since B1:C1 are merged cells, you only have to use the value from B1Please Login or Register to view this content.
Then again, xlnitwit's solution is much easier.
Last edited by gmr4evr1; 02-07-2018 at 01:46 PM.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Why do you need Merged cell/wrapped cell in B1:C1 ? I would eliminate it. Create a simple formula/function: mySt = sheet1.Range("B1") - You can verify it in immediate window ( debug.Print cstr(myst) ) or use Cstr( ) .
Thank you all for the responses. Each one of these solutions seemed to work. I would like to get rid of the merged cell, but the actual sheet that this is going in (not the one attached) was one that I inherited and I cannot change it without fixing a lot of editing the other formulas and Macros.
Thanks again!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks