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" wrote in message
...
|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