CodePlexProject Hosting for Open Source Software
How would I get the first columnNumber of a Range?
I was able to see through the object hierarchy in the watch that a Range has RangeParameters > RangeAddress > FirstAddress > ColumnNumber
but I'm not sure how to obtain this through code. Is there a way?
Take your pick...
That was too simple! Thanks! ;)
How to find it on an object of type NamedRange ?
Assuming the named range points to a single range:
var range = worksheet.Range("YourNamedRange");
var range = workbook.Range("YourNamedRange");
(depending on whether the named range has a worksheet or workbook scope)
Thanks it works ;O)
Are you sure you want to delete this post? You will not be able to recover it later.
Are you sure you want to delete this thread? You will not be able to recover it later.