View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pro_D Mike Pro_D Mike is offline
external usenet poster
 
Posts: 2
Default Module to make all absolute references relative

I'm using absolute references to allow a set of formulas to be copied across
and down a spreadsheet with only certain values changing relatively. After
the formulas are in place, I need all absolute references to be returned to
relative references so the sheet will still function when it is reformatted,
parts added/removed etc...

Couldn't a simple module be written to remove all "$" characters from cells
in the sheet?