Hi all,
I want to use the CHARACTERS in VBA on a cell that has a formula in it.
Is that possible?
Let's say I use the code below and put in A1 the value of 24 and in A2:
="A"&2*A1&"B"
Cell A2 then shows 'A48B' (as expected), but the code below does not highlight the number in red (which I expected it to do).
If I just type 'A48B' in a random cell, it does work fine. Does anyone have any bright ideas?
Please Login or Register to view this content.
Bookmarks