Using EntireColumn.AutoFit with variables

[eoinymc]

Hi,

I am trying to auto fit particular columns with a variable...

I have the following

Columns(CCol + 1 & ":" & CCol + 6).EntireColumn.AutoFit

but it doesn't work..

I get the error:

"Application-defined or object-defined error"

Any idea what the right syntax is?

Cheers,

Eoin

 

[Andrew Poulsom]

What's assigned to CCol?

 

[eoinymc]

An integer variable...

 

[Sektor]

Use letters instead of digits.

 

[eoinymc]

I can't use letters instead of digits because I am looping through and using the variables...

I think this will work?

Columns(CRow + 1).Resize(, CRow + 6).EntireColumn.AutoFit

 

[Andrew Poulsom]

This worked for me:

    Columns(CCol).Resize(, 7).EntireColumn.AutoFit

 

[eoinymc]

Thanks Andrew!

Similar to mine...

Regards,

Eoin