I am trying to go to "richardson" workbook sheet BIKE INVENTORY and # BIKES BUIL (with no T), find last row of data, and copy the data (col A to H) I get compile error on the fourth line Workbooks("RICHARDSON.......
Workbooks("BEST_TEMPLATE_for_FINAL_REPORT_Ver_20_DATA_ALL_STORES.xlsm").Sheets("DATAEACHSTORE").Range("AZ6")
thanks Carroll
[CODE]Private Sub CommandButton1_Click()
'RELOAD NEW DATA FOR EACH STORE FROM ASCEND QUERY REPORTS
Dim LROW As Long
'RELOAD NEW DATA RICHARDSON
Workbooks("RICHARDSON.xlsx").Sheets ("BIKE INVENTORY and # BIKES BUIL") '.Select
LROW = Range("A6").End(xlDown).Row
MsgBox " RICHARDSON LROW = " & LROW
Workbooks("RICHARDSON.xlsx").Sheets("BIKE INVENTORY and # BIKES BUIL").Range("A2:H" & LROW).Copy
Workbooks("RICHARDSON.xlsx").Sheets("BIKE INVENTORY and # BIKES BUIL").Range("A2:H" & LROW).Copy .Workbooks("BEST_TEMPLATE_for_FINAL_REPORT_Ver_20_DATA_ALL_STORES.xlsm").Sheets("DATAEACHSTORE").Range("AZ6")
Exit SubCODE]