I have a VB macro in Excel which applies some formatting to the worksheet.
On one PC, this line of code always gives an error 450: wrong number of arguments or invalid property assignment.
Columns("AK:AK").Select
Selection.Style = "Percent"
On other PCs, it works fine though. The only difference is that PC has 64-bit Office, whereas others have 32-bit. Is that code not valid for 64-bit?
4
could you also try:
Worksheets(“Sheet1”).Columns(“AK:AK”).Style = “Percent”
or indeed as Robert suggested
Worksheets(“Sheet1”).Columns(“AK:AK”).NumberFormat = “0.00%”