| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to same cell in other worksheet
I am analyzing various ranges in a worksheet. If a cell in the range is
empty, I want this cell to have the value of the same cell reference in another worksheet. Up to now I picked the value by using a relative reference within the worksheet, but I now have to pick the value from the same cell reference in another worksheet For Each rnCell In rnArea If rnCell.Value = "" Then rnCell.Formula = rnCell6.offset(23, 0).FormulaR1C1 End If Next Is there a solution? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to same cell in other worksheet
rnCell.Formula = Worksheets("Sheet2").Range(rnCell.Address).Formula
HTH -- AP "JW Rutgers" a écrit dans le message de . .. I am analyzing various ranges in a worksheet. If a cell in the range is empty, I want this cell to have the value of the same cell reference in another worksheet. Up to now I picked the value by using a relative reference within the worksheet, but I now have to pick the value from the same cell reference in another worksheet For Each rnCell In rnArea If rnCell.Value = "" Then rnCell.Formula = rnCell6.offset(23, 0).FormulaR1C1 End If Next Is there a solution? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to same cell in other worksheet
Thanks! It works great
"Ardus Petus" schreef in bericht ... rnCell.Formula = Worksheets("Sheet2").Range(rnCell.Address).Formula HTH -- AP "JW Rutgers" a écrit dans le message de . .. I am analyzing various ranges in a worksheet. If a cell in the range is empty, I want this cell to have the value of the same cell reference in another worksheet. Up to now I picked the value by using a relative reference within the worksheet, but I now have to pick the value from the same cell reference in another worksheet For Each rnCell In rnArea If rnCell.Value = "" Then rnCell.Formula = rnCell6.offset(23, 0).FormulaR1C1 End If Next Is there a solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
| Refer to a worksheet/name using cell contents? | Excel Worksheet Functions | |||
| How can I refer to a worksheet using text in a cell? | Excel Discussion (Misc queries) | |||
| refer to last cell in worksheet? | Excel Worksheet Functions | |||
| Using contents of cell to refer to a worksheet | Excel Programming | |||
Linear Mode
