Previous Topic Next Topic

Can vba return excel cell value with formats

[Closed]
Report
-
 Nosi -
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.

2 replies

Answer 1 / 2

Hi,

information of each letter is found with this parameter:
ActiveCell.Characters(i).Font.Bold 'i is index

This should get you started
13
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

hint: ActiveCell.Characters(i,j) may have second parameter, length (while first is start position)
Answer 2 / 2

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
Ask a question