Two Quick Questions

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

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
 
You could use Val.

Around here, it's a blue moon when Tom is wrong on a point/issue - in fact,
in the months I've been here, I've never seen it.
That said, typos happen. You'll need a fullstop before the word End
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Offset from an Application.Goto cell = Date or Time 10
Two Quick Questions 2
i = row number of last occurance of duplicate string Column A 4
format on change event 4
Array coding type mismatch 6
help please 4
Search multiple strings Difficult to figure out 2
Data Entry Form 1

Back
Top