Why "expected function" on such basic VB?

[Darin Kramer]

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 ***

 

[Snake Plissken]

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 ?

 

[Darin Kramer]

Thanks, I worked it out!

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

 

[Harald Staff]

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