Re: This has kept me up typing for hours...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


You need to make that reference static by placing a $ in front of them.
Then
when you copy them to other cells the reference will not change

If in A2 you have =A1 when you copy it to column B it will change to
=B1.
If you put =$A$1 when you copy it to B it remains =$A$1


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30153
View this thread: http://www.excelforum.com/showthread.php?threadid=510467

.

Relevant Pages

  • Re: code to make a block arrow point from cell A to cell B
    ... placing the shape on the workbook. ... Yo have to realize there is a border around the cells that ... position of a cell it will sit ontop or the border line around the ... You will see that if you use the code below the LeftSide and RightSide ...
    (microsoft.public.excel.programming)
  • Questions About ComboBox
    ... I have added a combobox to an Excel sheet. ... programmatically by placing them in cells in the worksheet. ... Is there another way to specify the list values other than placing them ...
    (microsoft.public.excel.programming)
  • row picking
    ... these rows somehow to refer to them by cells? ...
    (microsoft.public.excel)
  • Text To Columns
    ... column where "ADMIN1" would be, but I need it to go into the right ... Is there a way of me getting this information into the correct column? ... statement to add "/" to those cells which don't have them currently so ... Debrap29's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36127 ...
    (microsoft.public.excel.misc)
  • Re: Grouping into a Tab
    ... > Yes sorry for not placing one in before. ... >> to create macro to seperate each group into a tab. ... >> TheYellowDart ... >> TheYellowDart's Profile: ...
    (microsoft.public.excel.programming)