return the value of the active column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelvin - 21 Dec 2007 09:37 GMT

Any Ideas???

How would you capture the value the active column in a variable?

=column() will give the value of the active column

How would I use a variable to capture that value. val = column() ????

I would appreciate any help

Thanks

Signature

KWB

Reply to this Message

Rick Rothstein (MVP - VB) - 21 Dec 2007 10:00 GMT

We are talking about in a macro, right? If I understand your question
correctly...

Val = ActiveCell.Column

Rick

> Any Ideas???
>
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Kelvin - 22 Dec 2007 02:29 GMT

Thanks , that seems to work , I am getting the value in the variable.

I am now getting an error in my vlookup when I use val instead of 33?
Any ideas?

Thanks again

Signature

KWB

> We are talking about in a macro, right? If I understand your question
> correctly...
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message

Rick Rothstein (MVP - VB) - 22 Dec 2007 04:36 GMT

Sorry, I followed your lead and used the variable name you proposed in your
posting without paying attention to it. Val is a reserved key word in VBA
(there is a function by that name), so you can't use it as a variable name.
Just pick a different name and you should be okay.

Rick

> Thanks , that seems to work , I am getting the value in the variable.
>
[quoted text clipped - 22 lines]
>> >
>> > Thanks

Reply to this Message