I have been working on part of the code for my spreadsheet and it works fine in the spreadsheet “Databaseform” however when I copied the code to my master spreadsheet “Paul_PartLocDBCombo” it does not work, I get the error:
Method ‘range’ of object ‘_worksheet’ failed
The code is then highlighted in yellow, the code is:
Meaning this part is incorrect but I don’t know why? If it works on the other spreadsheet does anyone have any suggestions why it doesn’t work on this one?
Any guidance will be appreciated as its driving me crazy
To work it: go to Databaseform and press start. Enter 7mm in the product field and press find all. It will then return all the matching results in the userform. Its this I want to try and achieve on the other spreadsheet when the button find label is pressed.