Error 1004

[ehntd]

Hi, I have the following code:

Range("B1").activate

and when I run my program I get

ERROR 1004, error in activate method of the range class.

what is the problem?! Itīs just a simple activation of a range...

Thanks for your help.

[dominicb]

Good afternoon ehntd

Don't use Activate, use Select. Don't take it personally, VBA is the fussiest thing when it comes to correct syntax. Anyone who regularly programs with VBA is subject to fits of weeping and nashing of teeth when what seems like the simplest command in the world gets rejected with a confounding, meaningless error.

Keep trying. Good luck.

HTH

DominicB