Copy Cell.Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
I'm kind of confused about what goes where, but maybe it's as simple as:

workbooks("tbd.xls").worksheets("sheet1").range("f34").value = isum
or
workbooks("tbd.xls").worksheets("sheet1").cells(blastrow+2,"F").value = isum
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Cells 2
Active cell 3
VBA Formula Help 6
Activating Workbooks 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Listbox in VBA 1
Open four Wbooks, copy four columns from each to Master Wbook 16

Back
Top