Cell A2 Of Worksheet Keeps Changing

[Mooseman60]

Hi

I have userform to add new plant and equipment to a worksheet in another workbook. It is all working fine except that when i save to the worksheet it saves to the next available row A7, A8 andso on but also replaces Cell A2 with the same description Can anyone tell me why

I have posted the code i am using

Please Login or Register  to view this content.

[romperstomper]

Because you told it to:

Please Login or Register  to view this content.

[Mooseman60]

What do I need to do with the range to make it work

[romperstomper]

If you don't want A2 to change, just remove that line.

[Mooseman60]

Are you saying to remove the whole line below

Please Login or Register  to view this content.

I did try this but then it comes up with Subscript not found

[romperstomper]

Yes, remove the entire line. It is impossible for the removal of that line to cause the error you mention (unless you have event code in that worksheet to close the workbook, for example)

[Mooseman60]

It is still comimng up with Subscript out of range and is highlighting this line of code below even if I delete the close button which is only closing the userform

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[romperstomper]

Is that workbook open and does it contain a sheet called Suppliers?

[Mooseman60]

Yes the workbook is open and yes it does have a worksheet called suppliers

[romperstomper]

Well, either the workbook name or the worksheet name must be wrong, or you wouldn't get that particular error.