Hi All,
Is it possible to capture text color, through VBA, when using a Vlookup? My code is below. Basically, it copies colored text from Cell B11 on Sheet1, which is a merged cell of B11:P18. That colored text is then pasted into Sheet15 into a single cell that is matched with one of a list of company names. It then adds a Vlookup into B11, which references a dropdown menu with the company names, to find the text that was previously copied. However, it only is able to bring the text back into cell B11 as Black, because of the Vlookup. I need that text to be colored when it is brought back over through the Vlookup. Any ideas? All help is appreciated!! Thank you!
Please Login or Register to view this content.
Bookmarks