View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default Column of a defined name (office 2000 vs XP)?

Hi,

this works in office XP

vAddress =
Workbooks(sParameters.Parent.Name).Names(vName).Re fersTo
vCol = Range(vAddress).Column

but not in office 2000. There must be an incompatibility, I guess.

How can I know the column-number of a named range in Office 2000?

Thanks
Jos Vens