Running a Macro for Multiple Cells

[Guest001]

I'm currently working on the attached spreadsheet. I want to be able to highlight a few cells, say C8:E8, and then run a macro to insert data into the highlighted cells and also insert data into the cell 2 columns to the right of the last highlighted cell.

For example,

I highlight C8, D8 and E8 and then run the macro.

C8, D8 and E8 are all now "Works Area" and G8 is "Taper Position". This would change depending on the initially highlighted cells.

Ask me if you need any clarifications. All help is appreciated.

[Kenneth Hobson]

Please Login or Register  to view this content.