Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is the snippet of code I am working with:
Worksheets("basedata").Range("D7").Activate col = 0 Do While ActiveCell.Offset(0, col) < "" row = 2 Do While ActiveCell.Offset(row, col - 1) < "" ActiveCell.Offset(row, col).FormulaR1C1 = "=basedata1!RC*1.08" row = row + 1 Loop col = col + 1 Loop As you can see I have hard coded a value of 1.08 whereas I would like to set that value in the General sheet at D2. How do I fix the formula above to reference the General sheet at location D2. I have tried ActiveCell.Offset(row, col).FormulaR1C1 = "=basedata1!RC*General!D2" but that did not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Formula Questions (I hope) | New Users to Excel | |||
Simple one I hope???? | Excel Discussion (Misc queries) | |||
Newby questions - simple (I hope) | Excel Discussion (Misc queries) | |||
Simple questions (I hope) | Excel Programming | |||
Easy one (I hope) Using Sheet Names to reference sheets in other Workbooks | Excel Programming |