Rob,

Thanks very much. When I substituted 'Cash = CDbl(Str1)' for 'Cash
Val(Str1)', that did the trick. ;)
At that point, Cash is the correct integer without any commas, but o
course the named cell 'PROCEEDS' is already formatted as #,###.

Query: Tom says he does not believe there are any typos in:

Application.Goto Cells(Rows.Count, 1)End(xlUp).Offset(-10, 1), True

However, I get a Compile error: Expected: end of statement and 'End
is highlighted. I attempted to remedy, but could not. The syntax fo
Goto is
Goto([*Reference*], [Scroll]).

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27890