Finding a column in function of a specific cell

[Doflamingo]

Hi all,

I try to find the VBA code that would allow me to choose the ColumnWidth in function of a specific cell.

here is the code of that cell

Cells(12, a * 2 + 3)

with a variable a that allows to put elements of a listbox in the same row in different columns with for each item a supplementary separated column.

I try, in function of the code of that cell, to make evolve the columnwidth

Any ideas ?

I thought something like that

Range("A:A").select or Columns("E:E").Select and then Selection.ColumnWidth = 15 but changing a:a or e:e with the features of the cell which are Cells(12, a * 2 + 3)

 

[Tetra201]

Try

Cells(12, a * 2 + 3).ColumnWidth = 15

 

[Doflamingo]

Hello Tetra201, It works perfectly!! Thank you so much