Forum Discussion

DarrylH42022's avatar
DarrylH42022
Copper Contributor
Apr 04, 2022
Solved

autofit problems in 2013 spreadsheet

I am using Excel version 2013. I have opened an xls spreadsheet generated by our business application. I open the spreadsheet (excel says compatibility mode).   I creating a macro to do some formatt...
Macros and VBA
  • DarrylH42022's avatar
    DarrylH42022
    Apr 04, 2022
    OK. Figured it out. I was being stupid.
    It copied the value AND formatting. Once I only copied the value it works. duh.
DarrylH42022's avatar
DarrylH42022
Copper Contributor
Apr 04, 2022
OK. Figured it out. I was being stupid.
It copied the value AND formatting. Once I only copied the value it works. duh.

Resources