Conditional Formatting Macro .LineStyle = xlContinuous error

I am trying to create a macro that recreates the conditional formatting each time a cell is dragged and dropped

As the conditional formatting code is complex, I tried to use Excel's macro recorder to create the code for me.

A (much reduced) bit of the code is below, which aims to set borders on cells A1:AF11. I have set the formula to be "=TRUE" as all of cells A1:AF11 need to be set in this way [I realise that conditional formatting is not necessary here - the other 30+ bits of code which I haven't posted are "proper" conditional formats!]

Please Login or Register  to view this content.

Every time I run it, the line .LineStyle = xlContinuous gives me an error. How can I fix this?

I should have posted the error

The error is

run-time error '1004':

Unable to set the LineStyle property of the Border class


Also I am using Excel 2007

Your requirement is to put border/format A1:AF11 if user changes anything in the sheet?

Basically, yes

I do not have access to Excel 2007, not sure why you were using conditional formatting while recording the macro.
Just try to format the cells using borders/fill color using record macro, that should work.
Also, the above code did work for me except .TintAndShade = 0.

The reason for it being conditional is that in the final version of the workbook, not all cells need to have the border. I just haven't written the conditional expression yet, as I want to get this part of the code working first before I write the next bit. Easier to debug errors if I take it one step at a time

Please use macro recorder again to do the simple cell formating, do not delete any code and check if that works, later make necessary changes in the code, test it and keep adding your building blocks through seperate procedures.

If your selected range is, cells( A1:AF11),you can reduce the code by removing the selection part of the code

Please Login or Register  to view this content.

THanks, I think the last one sorted it

thanks both for all your help

Smeddlesboy,
I did not even test the code, but seems to work for you and I am glad it does