InStr function
Complex calculations with lots of dependencies are best done in Excel, because you don't have to keep track of all the
dependencies yourself.
It's also a matter of taste. Some programmers insist that calculations can easily be done in COBOL. Poor guys.....
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"AshGrant" wrote in message ...
| Hi again, no problem this time just a simple question.
| I am an advanced user with Access 2000, been programming VBA and designing
| accounts applications for 2 yrs now.
| Just wondering though, I want to improve my Excel skills and maybe create
| some useful apps in Excel. But whatever I think of, I always drift back to
| Access because it always seems to be easier and quicker.
| What would you typically use Excel for? I don't mean simple accounts
| spreadsheets, i'm talking more in terms of full applications with features
| aplenty.
| Bit confused on this one. It just seems that anything Excel can do, Access
| can do better...Correct me if i'm wrong.
|