View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Referencing 2 cells in a macro

I've got the following code which I am trying to add the following 2 columns
thru cell refences and am getting a compile error. I am not sure what I am
doing wrong since it works when I only reference 1 column.

Worksheets(Sh).Range("W" & X).FormulaR1C1 = "=((RC[" &
Sheet(1).Range("D32")+ RC[" & Sheet(1).Range("E32")& "]/Sheet1!R21C4*52)"

--
Thanks.

Bob