Thank you for responding...I guess I'm still confused as how I would use the
offset method in this situation.

would it look like this:

..linkedcell = "object.cells(i,3).offset(1,0)"

"Jim Rech" wrote:

> 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
>
>
>