Once you found your cell use the Offset method in whatever direction gives
you "one column over" and then the Address property of that.

--
Jim
"dstiefe" <dstiefe@discussions.microsoft.com> wrote in message
news:BFD6D9CC-A1CB-4A78-9119-F572F47FCF6A@microsoft.com...
|I am trying to , through VBA, scrollbars that link to certain cells.
|
| The problem is I do not know exactly where the scrollbar will be added.
So
| I am looping through the sheet for cells that contain "Total" when I find
it
| I want to add a scrollbar that "links" to the cell one column over. The
only
| way I have found the "Cell link" property to work for the scrollbar is if
| it's hardcoated. For example, ".linkedcell = "$B$3".
|
| How do i set the property for ".linkedcell" if I am uncertain about the
cell
| it will be linking to.
|
| visual example...http://www.myanalystteam.com/linked.ppt
| Thank you
|
| Daniel