How to refer to the value of a cell containing a VBA function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob at Great Waters - 21 Mar 2006 22:35 GMT

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

Reply to this Message

Dave Peterson - 22 Mar 2006 01:16 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message