I have a variable, CostChange, that is equal to the value of a given cell formatted as $#,##0.00. However, when I use CostChange in a message variable, such as:
Msg = "Unit cost increased by " & CostChange
CostChange loses all its formatting. How do I find a way to fix this?
Try
Msg = "Unit cost increased by " & Excel.WorksheetFunction.Text(CostChange, "$#,##0.00")
If CostChange is a number, it doesn't have formatting.
Another similar function:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks