VBA - Selecting all cells in specific columns from selected rows

I want to use VBA to aid personnel in removing formulas (ie copy and paste value) from specific columns in a worksheet once the data in each row or rows is finalised. The columns will be the same columns every time, but the rows will obviously change on each occasion as we finalise the data in each row or rows. Currently, user error means some columns are selected and values fixed in error before they are ready.

A B C D E
1 4 3 6 8 2
2 6 7 5 4 9
3 8 2 1 5 3
4 3 7 8 2 5
5 9 5 6 8 9

For example, in the above I would like to select rows 4 and 5 manually, then run some VBA to select all the cells in columns B and D for the selected row range (rows 4 and 5). Then I want to copy those cells and paste the values in situ.

I am fairly inexperienced with VBA code. I can achieve copying and pasting the values in situ using VBA, but I am struggling with the selection of multiple column ranges from just the rows selected. I would be most grateful for any help anyone can provide.

Thanks

If it's just the two columns try

Please Login or Register  to view this content.

Thanks Fluff13. My actual example involves around 60 columns to be selected and fixed out of a total 100 columns. Would this lead to suggesting to approach it another way, or should I simply replicate what youve suggested for all the columns I need fixed?
Thanks very much.

@Arkadi
That will copy the values in col B to col D as well.

How about

Please Login or Register  to view this content.

Thanks All, this is working perfectly now, and dovetails nicely with the code to change the colour of the cells as the values are fixed.

You're welcome