Hey,

Probably a really stupid question, but is there a way to make VBA code auto adjust when you change the worksheet?

For example, my VBA code is looking into A40, but if I want to modify my sheet and add a row at A10, the VBA code will still be looking at A40, when it should be looking at A41. Its a massive pain as i've made a huge amount of coding in a workbook and need to modify it now.

Thanks!

Joe