Dim myCell as range
set mycell = worksheets("somesheetname").range("SomeRangeName")

Then you can use something like:

msgbox mycell.column



Isis wrote:

I have named a cell on sheet - how doe I reference just the column property
of that named cell in vba on another sheet in the same workbook please ?

Thanks

--

Dave Peterson