I'm stepping through very basic VBA to re-learn some essentials.
I have two workbooks open, each with a couple of worksheets. No duplicate names. The two open sheets are called Track Data and TEMP respectively.
Why does this fail with subscript out of range please?
It works if I specify the workbook.Please Login or Register to view this content.
That involves finding its name and carefully pasting it into my code, so I'd prefer not to do so. Why must I specify it in this situation please? In what circumstances can it be left out?Please Login or Register to view this content.
Terry, East Grinstead, UK
Bookmarks