Solved COPY - DESTINATION coding

December 13, 2016 at 09:06:31
Specs: Windows 64
Sheets("ADMIN").Select
     nxtRow = Sheets("Legend").Range("AP" & Rows.Count).End(xlUp).Row + 1
      Sheets("ADMIN").Range("R20:S20").Copy _
       Destination:=Sheets("Legend").Range("AP" & nxtRow)

Hi guys,
The above coding has been running fine until I use it in Windows 10, Windows 7 previously
Know it will not function as required. What am I missing

Code determines the next available cell in the column and copies from the 'ADMIN' sheet to the 'Legend' sheet


See More: COPY - DESTINATION coding

Reply ↓  Report •


#1
December 14, 2016 at 00:03:59
✔ Best Answer
The code works perfectly fine for me in Windows 7 (Office 2010) and in Windows 10 (Office 2016).

What error message, if any do you receive?


Reply ↓  Report •

#2
December 14, 2016 at 10:18:17
AWTL,
Thanks for coming back, but resolved the issue, not sure how but coding is working fine
Again thanks for responding

Tony


Reply ↓  Report •

Related Solutions


Ask Question