im trying to select the batch input sheet and from what ive seen i should use the code
but i keep getting error 1004 and im not sure what is wrong
In VBA for Excel, what is the difference between
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
its still giving me the same error