Thread: [Solved] Copy two separate ranges from another workbook
View Single Post
 
Old 07-24-2018, 08:38 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2017
Posts: 89
kevinbradley57 is on a distinguished road
Default
NoSparks -- When I enter your suggested line of code (below), the colon in "H2:H" is highlighted and I get the following compile error: "Expected: list separator or )"

Code:
Range("H2").AutoFill Destination:=Range("H2:H" & lastrow)
Last edited by kevinbradley57; 07-24-2018 at 08:39 PM. Reason: typo
Reply With Quote