View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Len Dolby[_2_] Len Dolby[_2_] is offline
external usenet poster
 
Posts: 4
Default Change "relative" to "absolute" (database)

Routine to change datacell range BS5:BU80 from relative to absolute values,
please ?

(example, cell BS5 content "=C5+C80+C155+C305"

Excel method works only on single cells (select cell, highlight content in
function bar, press function key f4 3 times) BUT it doesn't work on a
highlighted range, neither can I construct an effective macro via macro
wizard.
I have 4 such data blocks (900 cells), and a short deadline for final report
print (tonight) which are these data blocks, data sorted (and data sort
doesn't work with relative values).
Any suggestion appreciated !

LEN