im trying to select the batch input sheet and from what ive seen i should use the code
Sheets(“Batch Input”).Select
but i keep getting error 1004 and im not sure what is wrong
1 Answers
In VBA for Excel, what is the difference between Sheets.Select
and Sheets.Activate
?
The difference is in their flexibility.
Activate
make the specified sheet the active sheet, and may only be applied to a single sheet
Select
allow for optionally extending the currently selected sheets to include the specified sheet
Try activate.
Your Answer