Thread: changing absolute reference for range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marpat marpat is offline
external usenet poster
  
Posts: 4
Default changing absolute reference for range of cells
How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
Reply With QuoteReply With Quote