Thread: [Solved] Loop - Row increment
View Single Post
 
Old 04-16-2015, 01:46 PM
Jhnsnkth527 Jhnsnkth527 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2015
Location: Cincinnati
Posts: 7
Jhnsnkth527 is on a distinguished road
Default

If I understand you code, it looks like you select a variable range to copy from "checks", but your PasteSpecial is to the same range "A1" every time. I'm guessing, the range should be Range("A" & a).
Reply With Quote