excel - Finding a VBAS defnied Named Range definition -


a valuei've inherited large vba project , whilst have lots of dev expereince have small amount of vba. code reads data off sheet in form:

intersect(range("colname"), .rows(intcurrentrow)).value 

where colname named range, or thought. have searched of project code , excel sheets , cannot find colname defined ?

so far have searched code, looked in name manager on sheet , have googled furiously hit total blank. need read in value sheet prefer use code used value instead of colname reference new data field.

is there obvious i'm missing ?

edits:

activesheet.range("colname").address gives value of "$l:$l"

its hidden name.as doug glancy said, can unhide using vba

activeworkbook.names("colname").visible=true 

if working defined names may find useful & jan karel pieterse's name manager addin (amongst many other things) handles hidden names. download from
http://www.decisionmodels.com/downloads.htm


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -