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