VBA Code to copy row but not formula?

[matrixpom]

Good day all,

I have a userform "command button" that populates a record into the next available row in Sheet "Form" when populated I have assigned a column to generate a unique number for the new row, once complete the code then transfers all data in that row to a second sheet "SWMS", the problem is it also copies the formula across & subsequently changes my unique code, how can I transfer just the data & not the formula?

Please Login or Register  to view this content.

Thank you all once again for your assistance, this site has been an amazing wealth of information for me - Marco

[protonLeah]

Please Login or Register  to view this content.

[matrixpom]

Hi protonLeah,

The title of "Forum Guru" is more than well deserved, works perfectly, thank you very much indeed!! Marco