Howdie,

Why do I get error "expected function"with this simple vb..?

Sheets("abc").Select
Cells.Select
selection.Clear

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

perhaps during compilation of ur code a function is expected in any other
place ? Do you use option explicit directive and you compiled manually ur
code before u run the macro ?

Thanks, I worked it out!

*** Sent via Developersdex http://www.developersdex.com ***

Hi

Adding, don't select and activate, it is unnecessary and slow in at least
99% of the cases. Just write

Sheets("abc").Cells.Clear

it runs invisible and fast, and your working environment doesn't change.

HTH. Best wishes Harald

"Darin Kramer" skrev i melding
...


Thanks, I worked it out!

*** Sent via Developersdex http://www.developersdex.com ***