Quote:
Originally Posted by trevorc
Thanks again,
But after copying your code as is nothing happened
...
perhaps oName is not pickup any names in the Activewookbook.Names
|
Well you keep referring to names, without clarifying whether you're referring to a named range or a column's designation. Some clarity wouldn't go astray.
Try:
ActiveWindow.ActivePane.VisibleRange.Cells(1, 1).EntireColumn.Address