bailey beck asked 2 years ago
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
Cairo answered 2 years ago
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
