Hi again guys,

I have a block of code that I use to update one register with information from another register based a matching cell value...
Please Login or Register  to view this content.
This code repeats 8 times, pulling 8 individual cell values across, however I need to add one more, but this time copy a range of cells rather than just one cell e.g. .Range("BB:BR"), could this code be adapted to achieve this? As always any assistance would be greatly appreciated, have a great day guys - Marc