Help with Non Contiguous Row Ranges

Hi All,

I've got the following code in use:

Please Login or Register  to view this content.

However I am getting a run time error 1004. Basically to cut a long story short I'm trying to future proof the macro so when people insert rows into the workbook the macro will handle it without me hard coding the different absolute references.

The absolute cell references as they are at the current time are:

Please Login or Register  to view this content.

I can get

Please Login or Register  to view this content.

to work only if I add speech marks to for example:

Please Login or Register  to view this content.

However the above also gives the cells inbetween e.g. A736 to A739 when I run the code through (which is not what I want). It's hopefully just a syntax thing if anyone can help?

Thanks

Chriz

BookLastRow is going to return the same as DVDLastrow... i.e. the last row of data in column A... You'll have to find another method to determine the last row of book data