This macro was working yesterday, today I can't get it to work no matter what I do (I've cut it out, saved, closed, reopened, tried different naming conventions) and I'm getting pretty frustrated, so am hoping for some help.
The code does 2 things:
1) Copies the selection from the Listbox ("RegionSelect") to another worksheet ("Steps")
2) Uses that value to copy and paste other items into the same sheet.
The first part is working, the second part gives me a "Run-Time error '94': Invalid Use of Null" error on this line:
The full code is reproduced below:Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks