how to force uppercase

[Ryan]

Hey Everybody,

Question for you all ... i want to be able to set a column to force
uppercase from another tab in the same worksheet ... this is what i have ...

=UPPER(ACTIVE!A4:A32)

where active is the name of tab i want this to take place ...

let me know ...

Thanks,
Ryan

[Ryan]

The problem is i get "VALUE" when i do this ... it works if i put it in the
same tab ... but wont pull from the other ones. Somebody tell me if this
possible. I have a "VARS" tab where i want my variables.

Thanks for the help

"Ryan" wrote:

> Hey Everybody,
>
> Question for you all ... i want to be able to set a column to force
> uppercase from another tab in the same worksheet ... this is what i have ...
>
> =UPPER(ACTIVE!A4:A32)
>
> where active is the name of tab i want this to take place ...
>
> let me know ...
>
> Thanks,
> Ryan

[Bryan Hessey]

Did you mean to say:

=UPPER(Active!A4)

and formula-copy this down to Row 32 ?

The problem is i get "VALUE" when i do this ... it works if i put it in the
same tab ... but wont pull from the other ones. Somebody tell me if this
possible. I have a "VARS" tab where i want my variables.

Thanks for the help

"Ryan" wrote:

> Hey Everybody,
>
> Question for you all ... i want to be able to set a column to force
> uppercase from another tab in the same worksheet ... this is what i have ...
>
> =UPPER(ACTIVE!A4:A32)
>
> where active is the name of tab i want this to take place ...
>
> let me know ...
>
> Thanks,
> Ryan