Excel Range issue

[Turtleman10]

I'm starting to play around with VBA in Excel and of course the first macro I write is Range("B3").Select which should work no problem but I get Invalid outside procedure and it highlights the B3 What in the world could I be doing wrong? THis is about as simple a command as you can get.

 

[PHV]

The error message is quite self explanatory: you have to write code inside a procedure, ie a Function or a Sub ...

 

[Turtleman10]

Nevermind it looks like there was something going on with my spreadsheet I closed Excel and opened a new workbook and all was fine. Go figure

 

[firefytr]

Best way to get started is actually the macro recorder. Just know that it is highly inefficient.

Zack

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP?
- Leonardo da Vinci