Do not know to how reference another sheet in my formual - embarrasingly simple I hope

C

Curious

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use a variable in the place of a sheet name 2
VLOOKUP Insert & Copy 24
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
application.goto reference using references in the worksheet 2
Configure macro to run on all sheets Excel 2k7 9
Shifting cells to consolidate record rows 4
Merging duplicates in a sheet 4
How can I indicate in a macro to which last sheet to return ? 9

Top