Table Format Columns | VBA

Bubna, Shreya 61 Reputation points

Hello, I have several tables in my workbook. I hope to format the columns of these tables with a parameters tab. On this tab, i will list out diffferent columns of this table and the format i want them to be in. For Example: Table ABC - ColumnA : abc | ColumnB : 123 | ColumnC : % and so on.

This column and format table is recognized as a table in excel called ABCParameters.

I need to use this ABCParameters Table as i cannot specify Column names - ColumnA/B/C by hardcoding into VBA. I need to keep them dynamic and reference using Parameters sheet table ABCParamters.

How can i do that on VBA.

Kindly help if possible.

{count} votes