Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have 2 workbooks: # 1 Workbook.("TBD.xls").worksheet("Sheet1") #2 is a workbook that I open with this VBA macro: fName = Application.GetOpenFilename Workbooks.Open filename:=fName I also have this VBA Macro blastrow = Cells(Rows.Count, "B").End(xlUp).Row isum = Application.WorksheetFunction.Sum(Range("b1:b10000 ")) Cells(blastrow + 2, "B").Value = isum My Question is: How do I Copy the value of "Isum" in the Workbook.("TBD.xls").worksheet("Sheet1") in cell "F34" Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic backup copy | Charts and Charting in Excel | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) | |||
Copy and Paste | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |