Cutting and pasting large variable text into a text box shape usin
Hello,
I am trying to create a macro that copies and pastes the resultant text of a column of vlookups into a text box(shape). The text returned can be rather lengthy, and not all the cells will necessarily return their text all the time. My question is, is it possible to overcome the 255 character string limitation in VB in order to copy and paste all the text from a cell into the text box before moving on the the next cell? I would also like the text from a new cell to appear on a new line, and blank cells not to appear at all. Is this possible? Thanks, Alan Lueke |
All times are GMT +1. The time now is 07:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com