(Solved) – vba applying format for table column

  • by

I am trying to apply a currency format to a specific column in a table.
I am trying 2 options:

Sheet1.ListObjects("MyTaqble").ListColumns("Balance").Style = "Currency"


Sheet1.ListObjects("MyTaqble").ListColumns("Balance").NumberFormat = _
    "_([$€-x-euro2] * #,##0.00_);_([$€-x-euro2] * (#,##0.00);_([$€-x-euro2] * ""-""??_);_(@_)"

For both I get the following error:
Object doesn’t support this property or method

What is the right way to apply format to a table column?

Leave a Reply

Your email address will not be published. Required fields are marked *