Poundland
07-14-2011, 02:37 AM
Hi guys,
I have some code that works in both 2007xl and 2003xl, and is actively working in vba codes ran on both variants, so I know that the code works...
Now the strange thing is that on one particular VBA project on xl2007 the code does not work, and I cannot for the life of me figure out why.. when it works in other projects... is there something fundamental that I am missing, perhaps file formats, permissions etc
The code is below, the error message received states Subscript our of range, yet I know the the Tab to be copyed and the destination file and tabs are all correctly named..
Sheets("Essentials Store Summary").Copy After:=Workbooks( _
"Availabilty Template.xls").Sheets("B Inv Missing Lines")
I have some code that works in both 2007xl and 2003xl, and is actively working in vba codes ran on both variants, so I know that the code works...
Now the strange thing is that on one particular VBA project on xl2007 the code does not work, and I cannot for the life of me figure out why.. when it works in other projects... is there something fundamental that I am missing, perhaps file formats, permissions etc
The code is below, the error message received states Subscript our of range, yet I know the the Tab to be copyed and the destination file and tabs are all correctly named..
Sheets("Essentials Store Summary").Copy After:=Workbooks( _
"Availabilty Template.xls").Sheets("B Inv Missing Lines")