Hi,

Does anyone have suggestions for the following:

The following code works great for adding the value of Cell A2 Sheet 2
to the last cell in column B Sheet 1.


Sub test()
Sheets("sheet2").Range("A2").Value = Sheets("sheet2").Range("A2").Value
+ _
Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Value
End Sub

I would like to add the last cell in Column B Sheet 1 in Workbook 1 to
the value of cell A2 sheet1 in Workbook 2.

Basically the same formula but adding cells from different
spreadsheets.

Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=483518