VB Code is correct but table fromats not getting updated.

Hi,

I have written a code for formatting the table to specific format, If I put in debugger mode and run the program means its getting updated correctly, but if I run directly the table is not getting updated . can you help in finding the issue. I attached the excel sheet for the table

Its working till the point of selecting the table for applying the borders, but its not applying borders.

Please Login or Register  to view this content.

It is difficult to test you code as there are a number of sheets that are missing. You have attached sheet3 only.
If you say the error occurs on for applying the borders, I suspect this is because you have with statement and then you start selecting the ranges which is bad idea IMO. You have already set up you with statement, so avoid using select. I have tried to do it, but I am not sure as I can not test it. I hope these lines would give you a good start

Please Login or Register  to view this content.

Hi,

I did the changes but still its not working. I attached the excel sheet with all details and macro in it. Please look in to pivot macro in it.


Thanks in Advance,
Menaka B

Menaka,
I have now tested your code. There is no error and all the lines of the code are working as intended. The bordering occurs on sheet3. I have removed them and run the code and it does all the bordering and lining.