Determining Column Based on Range Name

**PosseJohn** · 12-13-2013, 01:52 PM

I would like to determine which column number my named range refers to..

WS.Name = Limits
Range Name = LimitsStart
Refers to "=Limits!$U$1"

Are there any properties of a Named Range that I can use within VBA?

**fredlo2010** · 12-13-2013, 02:05 PM

try something like this

Please Login or Register  to view this content.

Thanks

**xlbiznes** · 12-13-2013, 02:09 PM

Hi,

try this code to understand how it works and apply this to your requirement.

Please Login or Register  to view this content.

**PosseJohn** · 12-13-2013, 02:10 PM

Wahooo!!

Thank you.

**xlbiznes** · 12-13-2013, 02:27 PM

@PosseJohn,

You are welcome, glad i could help.

Determining Column Based on Range Name

LinkBack

Thread Tools

Rate This Thread

Display

Determining Column Based on Range Name

Re: Determining Column Based on Range Name

Re: Determining Column Based on Range Name

Re: Determining Column Based on Range Name

Re: Determining Column Based on Range Name

Thread Information

Users Browsing this Thread

Similar Threads

Named range that returns range in column A based on criteria looking at column B

[SOLVED] Determining Cost Period based upon number of Tags in a 6 Month Range

Determining a price based on a range of values

determining range

[SOLVED] Determining if values in a column range are of same value.

Bookmarks

Bookmarks

Posting Permissions