Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

Last Column From Named Range

Hello All,

Is there a VBA way to find this: this function takes in a named range as argument or any other way and then spits out the first and the last column letters for the range…can this be done?
nyFunc(“namedRange”)

returns first column letter and last column letter
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

h
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

I had to increase the overall points to ensure each of you gets points for effort...thank you so much for your diligence and timely help :)
Avatar of Rayne

ASKER

Increased points
Avatar of Rayne

ASKER

..
Avatar of Rayne

ASKER

Hmm, I tried to increase the points several times but the site will not let me do that but it still shows the option to increase the points...this is site bug but anyways thank you all

Respect..
Don't worry about the extra points. I'm glad I was able to help.

Marty - MVP 2009 to 2012