ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro not formatting correctly (https://www.excelbanter.com/excel-discussion-misc-queries/74436-macro-not-formatting-correctly.html)

js8373

Macro not formatting correctly
 
I programmed a macro in VB that takes a .CSV file and formats it into a
report by, calculating formulas, sorting and other basic formatting. I
distributed it to roughly 30 users. The macro runs great for all but 1
user. When this 1 user runs the macro, the column width for all columns is
being set to 255. A Freeze pane is also supposed to be set for cell J2, but
is being set at A13 instead. The user is running MS Excel 2002, which is the
same version I programmed the macro.

Does anyone know where I should begin looking to resolve this issue?? Thank
you.


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com