Thread: How do I create a macro with relative address?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] donna.gough@hydro.com is offline
external usenet poster
  
Posts: 81
Default How do I create a macro with relative address?
Demokritos

Do you mean something along these lines...

ActiveCell.FormulaR1C1 = "=RC[2]+R[2]C[2]"
ActiveCell.FormulaR1C1 = "=R[2]C+R[2]C[2]"

......although I prefer to use offset(rows,columns).

The flag you are after in Excel 2000 can be found in
Tools - Options - General Tab

Haven't got 2003 but perhaps it hasn't moved.

Donna

Reply With QuoteReply With Quote