View Single Post
  #2   Spotlight this post!  
Unread 04-11-2014, 13:39
Alan Anderson's Avatar
Alan Anderson Alan Anderson is offline
Software Architect
FRC #0045 (TechnoKats)
Team Role: Mentor
 
Join Date: Feb 2004
Rookie Year: 2004
Location: Kokomo, Indiana
Posts: 9,113
Alan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond reputeAlan Anderson has a reputation beyond repute
Re: Non-Robotics: VBA for Excel?

Quote:
Originally Posted by indieFan View Post
I have vba code that works with Excel 2007 just fine. A co-worker now has 2013 installed and is getting errors. Is there a reason the following line wouldn't work with 2013?

Workbooks(2).ActiveSheet.Columns("V").Select
Are there actually two workbooks opened on the co-worker's system when that line is run? What is the error?