View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sly Sly is offline
external usenet poster
 
Posts: 11
Default changing cell references

Is there an easy way to change a cell ref without having to go in the cell to
change that ref

IE

A B
1 sheet2!A5 sheet2!B5

I want to change those cell ref to

1 sheet2!A6 sheet2!B5

Using an other cell to icrease the lookup reference