Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reference to an other excell book to get the value
The following logic exist to form an archive of the changing values of A1
and A2 [.Cells(xlr, 8) = .Range("A1")]. How the term [.Range("A1")] will change if the cell A1 is from an other excel book (a "book1" in the desktop)? Sub ArchiveA2() Dim xlr As Long With Sheets("Sheet1") .Range("G1") = "Value" xlr = .Cells(Rows.Count, "G").End(xlUp).Row + 1 .Cells(xlr, 7) = Format(Date, "dd/mm/yyyy") .Cells(xlr, 8) = .Range("A1") .Cells(xlr, 9) = .Range("A2") End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Conversion - why does this appear when I open excell wk book | Excel Worksheet Functions | |||
How do I email one sheet from within an excell work book file | Excel Worksheet Functions | |||
VBA Reference Book | Excel Programming | |||
VBA Reference Book? | Excel Discussion (Misc queries) | |||
VBA Reference Book? | Excel Programming |