I have the following code which is stored in a module, that when called, it runs for a userform
wBook.Sheets(1).Rows(Adnap_004_New_Employee.PGE_SELECTOR.Caption & ":" & Adnap_004_New_Employee.PGE_SELECTOR.Caption).Delete
Basically is does this:
wBook.Sheets(1).Rows("5:5").Delete
However the row may change from time to time so my first code is used to preempt that.
This code used to work, however it now throws an error when the PGE_SELECTOR visibility is set to false on the userform
The error is
Run-time error '13': Type mismatch
Any ideas why it only appears to work when the PGE_SELECTOR (this is a just a label) is set to TRUE visibility?
Bookmarks