J
J.W. Aldridge
Check to see if a workbook entitled "All_tne...." is open.
("..." represents other miscellaneous wording).
If open, select 1st worksheet in this workbook. (Will only be one
worksheet in workbook.)
Copy this range.
Range("a4:f4").Select
Range(Selection, Selection.End(xlDown)).Select
Go to workbook entitled "Apples and oranges"
Go to sheet "blueberries"
Paste at range a4:f4.
("..." represents other miscellaneous wording).
If open, select 1st worksheet in this workbook. (Will only be one
worksheet in workbook.)
Copy this range.
Range("a4:f4").Select
Range(Selection, Selection.End(xlDown)).Select
Go to workbook entitled "Apples and oranges"
Go to sheet "blueberries"
Paste at range a4:f4.