Teasee
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2 articles for 0.302 sec
Best solution is to copy and paste the previous values (paste special - values) then put them somewhere safe for the time being (say you have 900 values select c2:c901 for example.) into a new clean sheet. Now select all of the results cells (c2:c901 and drag them over 1 cell to column D, d2:d901 this will automatically change the links. Now paste the old results back into the position     

Group: microsoft.public.excel.misc · Group Profile · Search for Teasee in microsoft.public.excel.misc
Author: DazzaData
Date: May 30, 2007 07:30

Are these checkboxes from the Forms toolbar? If yes: ption Explicit Sub testme() Dim CBX As CheckBox Dim wks As Worksheet Set wks = Worksheets("sheet1") For Each CBX In wks.CheckBoxes CBX.LinkedCell = Application.Range(CBX.LinkedCell).Offset(0, 1) _ .Address(external:=True) Next CBX End Sub Teasee wrote:
Show full article (2.16Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Teasee in microsoft.public.excel.misc
Author: Dave Peterson
Date: May 30, 2007 07:24

Show full article (1.06Kb) · Show article thread