I have a spreadsheet that is drawn from a real-time
databse. The cells I need to work with are text formatted
with numbers having commas and decimals (e.g. 1,000.00).
Excel has a function called VALUE()which can convert a
text string to numeric, but it is not available in VBA.
VBA does have a similar function called Val(), but it
won't work if the text string has commas.

Can anyone suggest a VBA function or subroutine that can
convert a text string having numbers with commas to
numeric? Thanks.