So I think I must be missing something because I have done VBA code just like this before and it worked fine. For some reason I keep running into an error when I get to this line of code
z1 and y are both used to count rows on separate sheets. In this case the first instance of z1 is 1 and y is 3.![]()
sh1wy.Range(Cells(z1, 1), Cells(z1, 55)).Value = sh1wd.Range(Cells(y, 6), Cells(y, 60)).Value
Does anyone see what I am doing wrong here?
Bookmarks