re-writing VBA Code

Hi all,

I came across a VBA code the other day that is exactly what I needed (I am new to writing VBA code!), however the code is quite extensive and is written for a spreadsheet where the clumns start B and row 5 but I want use for a spreadsheet that starts at A1. The code was written for worksheets 'Open' and 'Closed' but I want to use it for my spreadsheet, which contains the works 'Risk Framework' and 'Archived Risks'. I have included two spreadsheets. 'move rows' is where the code is and 'Risk Frame Register' is where I want the code to be.

What I basically need is for the VBA code used on worksheets 'Open' and 'Closed' to also work on 'Risk Framework' and 'Archived Risks' as at the moment it is written with the 'Open' and 'Closed' worksheets and I can't (as hard as I've tried) been able to re-write the code for worksheets 'Risk Framework' and 'Archived Risks' because as you will see the tables are in different columns and cells. I don't need the code to work on all four work sheets just on Risk Framework and Archived Risks.

The code is on worksheets 'Open' and 'Closed' and I want to use it for my worksheets 'Risk Framework' and 'Archived Risks'. Sorry if I sound confusing, let me know if you need me to clarify.

Thanks in advance for all your help.

Hi Mehmet, firstly thank you for your response. It's much appreciated.

I don't know if I am doing something wrong but I am getting error '457' when I try and use the userform.

Apologies, if I am doing something wrong.