Thread: changing lists of cells to absolute values using a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Allerum30 Allerum30 is offline
external usenet poster
  
Posts: 1
Default changing lists of cells to absolute values using a macro
I need to change several lists of cells from normal(ie. cell A1 shows the
value in cell C4) I need to change that value to $C$4. I do it by clicking
the cell and hitting F2 then F4. For a list of 20 cells. When I try to use a
macro to perform this function(using relative reference or not)all it does is
give me a list of 20 $C$4's. what am I doing wrong?
Reply With QuoteReply With Quote