Excel Quirky issue???? with french decimal separators

Hello, I'm having a wierd issue with vba and it's driving me nuts. I have a macro that produces pricelists and outputs them to pdf, the macro produces bot english and french pdf versions so when it comes to french I have to convert the decimal separator to a comma. problem is the sheet does not take the formatting, the column widths don't get adjusted and the numbers do not get 2 decimal places. But when i put a break point to see where the problem is everything works fine and it takes all the formatting as it should. I have tried turning screen updating back on for this section of code, I have tried making the sheet recalculate, none of it seems to work. please help.

Chris

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Wherever you have Cells or Range, you need a dot/full stop/point in front of it to link it to the With SheetNum, that is .Cells and .Range


Regards, TMS

retracted... good eye TMS

so where do i put these dots?

I've told you. Wherever you have Cells or Range. The difference could be the sheet that is selected when the code is run. I take it you haven't tried the suggestion?

Suggest you post a sample workbook.

Maybe this approach:

Please Login or Register  to view this content.

Regards, TMS

Of course, that was just an example to demonstrate the use of Union.

You're welcome. Thanks for the rep.