View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordi Jordi is offline
external usenet poster
 
Posts: 7
Default ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"

If I exectue this simple code :

Range("F8").Select
ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"

It works great if I execute if from the current workbook but if the code is
in another workbook and I include:
Windows("Libro1").Activate

It raises error 1004

Any help?