I hope this isnt too much of a newbie question... its been years since I
last did any serious VB programming.

I have a body of code that has just finished working with a range of rows
set by:

Rows(4 & ":" & intLastRow).Select ' select all active rows

and now I want to format column A. So I try setting column A to be the
active and selected column with

Columns("A:A").Select ' select column A

however it returns a range of Columns("A:U"). I have also tried
Columns(1).Select and
Range("A:A").activate with the same results.


What am I doing wrong here?

Thanks much

Try
Columns("A:A").NumberFormat = "General"

instead of

Columns("A:A").Select

Do you have those bleeping merged cells in column A to column U?

They can screw up lots of things.

And to make matters worse, each version of excel seems to treat merged cells
differently.

Roger Smith wrote:
>
> I hope this isnt too much of a newbie question... its been years since I
> last did any serious VB programming.
>
> I have a body of code that has just finished working with a range of rows
> set by:
>
> Rows(4 & ":" & intLastRow).Select ' select all active rows
>
> and now I want to format column A. So I try setting column A to be the
> active and selected column with
>
> Columns("A:A").Select ' select column A
>
> however it returns a range of Columns("A:U"). I have also tried
> Columns(1).Select and
> Range("A:A").activate with the same results.
>
> What am I doing wrong here?
>
> Thanks much

--

Dave Peterson

Thanks Dave - you nailed it... way down deep in the report there was a
section where A to U was merged. Much thanks to you and a warning to fellow
programmers... those merged cells can indeed really screw things up like
crazy and yield results that, at first glance, seem to be way out of line
with the intended action.

Cheers,

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Do you have those bleeping merged cells in column A to column U?
>
> They can screw up lots of things.
>
> And to make matters worse, each version of excel seems to treat merged
> cells
> differently.
>
> Roger Smith wrote:
>>
>> I hope this isnt too much of a newbie question... its been years since I
>> last did any serious VB programming.
>>
>> I have a body of code that has just finished working with a range of rows
>> set by:
>>
>> Rows(4 & ":" & intLastRow).Select ' select all active
>> rows
>>
>> and now I want to format column A. So I try setting column A to be the
>> active and selected column with
>>
>> Columns("A:A").Select ' select column A
>>
>> however it returns a range of Columns("A:U"). I have also tried
>> Columns(1).Select and
>> Range("A:A").activate with the same results.
>>
>> What am I doing wrong here?
>>
>> Thanks much
>
> --
>
> Dave Peterson

Merged Cells.................the best thing to come along since the Edsel


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 15:26:36 -0700, "Roger Smith" <(E-Mail Removed)>
wrote:

>Thanks Dave - you nailed it... way down deep in the report there was a
>section where A to U was merged. Much thanks to you and a warning to fellow
>programmers... those merged cells can indeed really screw things up like
>crazy and yield results that, at first glance, seem to be way out of line
>with the intended action.
>
>Cheers,
>
>"Dave Peterson" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> Do you have those bleeping merged cells in column A to column U?
>>
>> They can screw up lots of things.
>>
>> And to make matters worse, each version of excel seems to treat merged
>> cells
>> differently.
>>
>> Roger Smith wrote:
>>>
>>> I hope this isnt too much of a newbie question... its been years since I
>>> last did any serious VB programming.
>>>
>>> I have a body of code that has just finished working with a range of rows
>>> set by:
>>>
>>> Rows(4 & ":" & intLastRow).Select ' select all active
>>> rows
>>>
>>> and now I want to format column A. So I try setting column A to be the
>>> active and selected column with
>>>
>>> Columns("A:A").Select ' select column A
>>>
>>> however it returns a range of Columns("A:U"). I have also tried
>>> Columns(1).Select and
>>> Range("A:A").activate with the same results.
>>>
>>> What am I doing wrong here?
>>>
>>> Thanks much
>>
>> --
>>
>> Dave Peterson
>