10-23-2008, 05:41 PM
Sheets("Weekly Prices without taxes").Select
"Weekly Prices without taxes" is different each time? Replace it to sheet index, if it does not change.
This selects first worksheet:
Sheets(1).Select
"Weekly Prices without taxes" is different each time? Replace it to sheet index, if it does not change.
This selects first worksheet:
Sheets(1).Select