upobDaPlaya
asked on
How do I replace a cell value but the formatting
I have ThisWorkbook(MySheet).Rang e("A4").Va lue = "David"
However, when the value replaces whatever was previously in "A4" I also lose the formatting. Any suggestions ?
However, when the value replaces whatever was previously in "A4" I also lose the formatting. Any suggestions ?
ASKER
How would I update a column in vba to reflect Aria 10..Note I am putting backcolor into the cell via VBA, but I am not doing any formatting..
What's aria 10?
ASKER
sorry arial 10... font family and size
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect ! thx
Glad to help
Thomas
Thomas
Or there's a worksheet_change macro at work, but it's less likely.