Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Range issue

Status
Not open for further replies.
Turtleman10

Turtleman10

Technical User
Sep 13, 2012
40
0
0
US
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.
 
Sort by date Sort by votes
The error message is quite self explanatory: you have to write code inside a procedure, ie a Function or a Sub ...
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
160
huiettcm
huiettcm
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
603
dhookom
dhookom
combo
  • Locked
  • Helpful tip
Excel VBA Range.Cells.Count limitation 1
Replies
1
Views
62
SkipVought
S
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
220
SkipVought
S
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
161
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top