Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to the value of a cell containing a VBA function?
I have a VBA function in a cell of one worksheet and want to use the value in
a cell of another worksheet. I haven't been able to figure out how to do that. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to the value of a cell containing a VBA function?
workbooks("book2.xls").worksheets("sheet2").range( "a2").value _
= workbooks("book1.xls").worksheets("sheet1").range( "a1").value is one way. if they're in the same workbook: with workbooks("book1.xls") .worksheets("sheet2").range("a2").value _ = .worksheets("sheet1").range("a1").value end with Bob at Great Waters wrote: I have a VBA function in a cell of one worksheet and want to use the value in a cell of another worksheet. I haven't been able to figure out how to do that. Bob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank Function: Refer to more than one range | Excel Worksheet Functions | |||
How do I refer to the results of a function in a cell not the form | Excel Worksheet Functions | |||
Refer to selected cell in custom function | Excel Programming | |||
Refer to the cell in which a function is entered. | Excel Programming | |||
How to ensure function does not refer to cells outside of workbook? | Excel Programming |