roulietta2424
New Member
- Joined
- Aug 16, 2010
- Messages
- 3
Hi,
The first part of my program is about a solver that creates a new sheet with the same format everytime it runs so the user can keep a trace of different scenarios.
But now i have another sheet called "Data Comparison" and I want to define two cells where the user can add the name of the sheets/scenarios he want to compare. the goal is to calculate different ratios.
All I can do is use this Formula and I had to add manually for each cell.
Worksheets("Data Comparison").Range("C19").Select
ActiveCell.FormulaR1C1 = "=INDIRECT(""'""& R[-8]C[-0] &""'""& ""!""&""C3"")"
Worksheets("Data Comparison").Range("D19").Select
ActiveCell.FormulaR1C1 = "=INDIRECT(""'""& R[-7]C[-1] &""'""& ""!""&""C3"")"
The first part of my program is about a solver that creates a new sheet with the same format everytime it runs so the user can keep a trace of different scenarios.
But now i have another sheet called "Data Comparison" and I want to define two cells where the user can add the name of the sheets/scenarios he want to compare. the goal is to calculate different ratios.
All I can do is use this Formula and I had to add manually for each cell.
Worksheets("Data Comparison").Range("C19").Select
ActiveCell.FormulaR1C1 = "=INDIRECT(""'""& R[-8]C[-0] &""'""& ""!""&""C3"")"
Worksheets("Data Comparison").Range("D19").Select
ActiveCell.FormulaR1C1 = "=INDIRECT(""'""& R[-7]C[-1] &""'""& ""!""&""C3"")"