selecting sheet

Questions ArchiveCategory: Questionsselecting sheet
bailey beck asked 3 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 3 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

18 + 9 =