#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Dividelink

In cell A1 Sheet 2, I want to put the result of Sheet 1 F37/F36 and then link
cell G1 Sheet 2 to F36 and I1 Sheet 2 to F37. This is the formula I am using
now.

Sub Dividelink()
Range("A1").Select
ActiveCell.FormulaR1C1 = "='Sheet 1'!R[36]C[5]/' Sheet 1'!R[35]C[5]"
Range("G1").Select
ActiveCell.FormulaR1C1 = "='Sheet 1'!R[35]C[-1]"
Range("I1").Select
ActiveCell.FormulaR1C1 = "=' Sheet 1'!R[36]C[-3]"
Range("I1").Select
End Sub

Is there an easier way to do this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"