I used the macro recorder to get the code to resize columns on a worksheet

Cells.Select
Range("A1766").Activate
Cells.EntireColumn.AutoFit

What I don't understand in the Range. It's seems to be referring to a
single cell. Could someone explain to a VBA newbie?

I'm importing a text file and I want to resize the columns after import.
I have the import working just need this one last thing.

The worksheet will always have the same number of columns but the number
of rows may vary will the above code still work?

gls858

gls858 wrote:
I used the macro recorder to get the code to resize columns on a worksheet

Cells.Select
Range("A1766").Activate
Cells.EntireColumn.AutoFit

What I don't understand in the Range. It's seems to be referring to a
single cell. Could someone explain to a VBA newbie?

I'm importing a text file and I want to resize the columns after import.
I have the import working just need this one last thing.

The worksheet will always have the same number of columns but the number
of rows may vary will the above code still work?

gls858

That supposed to be easy macro question

The range is a single cell, but you use entirecolumn later.

I would just use

Columns(1).Autofit

or

Columns("A").Autofit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"gls858" wrote in message
...
I used the macro recorder to get the code to resize columns on a worksheet

Cells.Select
Range("A1766").Activate
Cells.EntireColumn.AutoFit

What I don't understand in the Range. It's seems to be referring to a
single cell. Could someone explain to a VBA newbie?

I'm importing a text file and I want to resize the columns after import.
I have the import working just need this one last thing.

The worksheet will always have the same number of columns but the number
of rows may vary will the above code still work?

gls858

Bob Phillips wrote:
The range is a single cell, but you use entirecolumn later.

I would just use

Columns(1).Autofit

or

Columns("A").Autofit


Thanks Bob. I just posted what the recorder recorded. I'm a newbie when
it comes to VBA. I'll give your suggestion a try.

gls858

This is what I get in XL97 when I use the Macro Recorder:

Cells.Select
Selection.Columns.AutoFit

You can of course take out the two Selects and just have:

Cells.Columns.AutoFit

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"gls858" wrote in message
...
I used the macro recorder to get the code to resize columns on a worksheet

Cells.Select
Range("A1766").Activate
Cells.EntireColumn.AutoFit

What I don't understand in the Range. It's seems to be referring to a
single cell. Could someone explain to a VBA newbie?

I'm importing a text file and I want to resize the columns after import.
I have the import working just need this one last thing.

The worksheet will always have the same number of columns but the number
of rows may vary will the above code still work?

gls858

That is the problem with the MR, it records every step. So you select a
cell, then you autofit the column, two steps, so that is what the MR
records. A bit of a pain, but understandable.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"gls858" wrote in message
...
Bob Phillips wrote:
The range is a single cell, but you use entirecolumn later.

I would just use

Columns(1).Autofit

or

Columns("A").Autofit


Thanks Bob. I just posted what the recorder recorded. I'm a newbie when it
comes to VBA. I'll give your suggestion a try.

gls858

Sandy Mann wrote:
This is what I get in XL97 when I use the Macro Recorder:

Cells.Select
Selection.Columns.AutoFit

You can of course take out the two Selects and just have:

Cells.Columns.AutoFit


Thanks for the input Sandy.

gls858