Tidying up VBA code

[MrBibby]

Hello,

I've made a vba which when run copys cell values from a specific row on the 'Data' sheet to various cells in a 'process' sheet.

It does the job, but doesn't seem like the most efficent way to do it - can anyone suggest a way to do the same thing better?

(M2 on the Process sheet contains the row number to look for on the data sheet.)

Please Login or Register  to view this content.

Thanks!

[MrBibby]

Ok, I've removed the unnecessary use of the Index function as I already knew both the column and row - duh!

Here is my revised version:

Please Login or Register  to view this content.

It's fast, but not instant, which makes me think its doing more work than it needs to in the background.