run-time error '1004' method 'range' of object '_global' failed

I have a code that generates the part called "Machined" from already existing parts in the list called "As wound".

This macro inserts number of rows specified by the user in the input box and fills in appropriate cells.

Code does work perfectly fine if the sample selected is at the first position of the table (Row 9) , but anything that is below this row will prompt with an error:

"run-time error '1004' method 'range' of object '_global' failed"


Here is my file

example.xlsm

Many thanks

Originally Posted by Norie

Which sub should we be looking at?

machining_gen

sorry should have removed the others

Originally Posted by Norie

I tried that and couldn't generate an error.

Is there anything specific I should be doing/entering?

make sure you are generating the part that is second on the list in the Mk6e-i2 GR tab
,

in "Machining" tab put 55 in cell J10
and click generate part

Originally Posted by Norie

The reason for the error is that myrange is empty, why it's empty I'm not sure yet but I think it could be because the selected ID isn't being found.

I found some problems in your code, specifically with one line if statements and Exit For.

I've, hopefully, fixed some of those problems in the following code.

Can't guarantee it does what it's supposed to, not too sure what that is - lot of looping going on, but this runs without error.

Please Login or Register  to view this content.

almost well done:P

IT does run but for some reason it does not put letters to new part starting from an "A" even though it suppose to according to code.

Originally Posted by Norie

Does it do anything?

yes it works apart from inserting letter not staring with an "A" as it suppose to according to

Please Login or Register  to view this content.

chr(56) is an "A"