How to refer to table columns in VBA?

[Kyletok]

I know I can refer to a table with []

so right now I have

[TABLENAME].Rows(X).Columns(Y) = Value

Can I also refer to a column with a column name without setting a variable for it?

I set it as a variable in case I added columns in the table, so in the macro pulls Y from the sheet which lets it know which column the column I want is in, Column(tablename[columnname])

is it possible to do [TABLENAME].[ColumnNAME]
or something of the sort

 

[James006]

Hi,

You could test following :

[COLOR=#000000][FONT=Courier New]ActiveSheet.Range("Table1[Column2]").Select[/FONT][/COLOR]

HTH

 

[DanteAmor]

It may be so:
DESCRIPTION is column name
4 is the row number (DataBodyRange = data only)

ActiveSheet.ListObjects("Tabla1").ListColumns("DESCRIPTION").DataBodyRange.Cells(4).Value = "data"