can vba return excel cell value with formats Closed

Question

Hello, I have entered text "ABCDEFGHI" into an Excel cell. I have changed the font of "DEF" to bold. Is there a way for VBA to return the value in the cell along with formatting information.
Sample cell content: 

ABCDEFGHI

Thank you.

tl · Accepted Answer

Hi,

information of each letter is found with this parameter:
ActiveCell.Characters(i).Font.Bold 'i is index

This should get you started

Nosi · Answer

hi my friend I think it is working try it:

this is for fixing cells and return the value of the cell to the original:

function fixit(cell)
if not cell.hasformula and not isempty(cell) then
fixit=val(cell)
end if 
end function

Can vba return excel cell value with formats

2 responses

Similar discussions

Subscribe To Our Newsletter!