Cell Range from the address

[kiran527]

Hi,

i have a macro running which produces me cell address like $GL$3

from the above cell address i just need GL. could you please tell the macro tip to achieve this?

Quick reply will be appreciated.

Thanks in advance...

[patel45]

Please Login or Register  to view this content.

[kiran527]

Thanks patel, but i have a question,, i my macro returns only $A$4 then the same code which you have given is applicable??

[Norie]

What do you need the GL for?

[kiran527]

i have a macro to get the cell address for the value given in a macro.. it searches for a given value in the exceel sheet and gives me cell address, but the cell address is returned as $GL$4, but i need only GL so that i can get identify the range as GL1 to GLn..

[HaHoBe]

Hi, kiran527,

the answer to your question to patel45 is: no.

Maybe use Cells instead of Range and work with the numeric value of the address:

Please Login or Register  to view this content.

Ciao,
Holger

[Andy Pope]

Please Login or Register  to view this content.

You would replace the text $GL$3 with the variable.

[Norie]

As Holger says, you could use the column number.

You might even be able to get that from the code that produces the address.

[Winon]

It sounds Like you only want to have the Active Column displayed.

If so, try this:

Please Login or Register  to view this content.

[kiran527]

Thanks Holger, your solutions is working for me.. thats cool.. thanks one again