Applying Conditional Formatting to a Range in VBA (range is set by variables)

So, i'm writing a macro to take multiple CSV downloads and merge them to one worksheet so it can be audited. However, some of the data is incomplete so once the worksheet has been put together, i want to apply a conditional format to the range we have just created to highlight blank cells.


My code is:

Please Login or Register  to view this content.

Hi, thank you - i put Destrange.Select at the start of your code i no longer get the error.

However, although the conditional format appears to have been set it a) only seems to be looking at cell F16 and b) and doesn't appear to alter the range.

So i tried the below and still get run time error 5

Please Login or Register  to view this content.

Thanks, i've tried defining the range both with your method:

Please Login or Register  to view this content.

and another method:

Please Login or Register  to view this content.

and it fails on this line for both:

Please Login or Register  to view this content.

Thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaankk You!

It was the Extra """ that was throwing the syntax - i was banging my head on a brick wall over that one...

Super Stars! Cheers guys