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.
Please Login or Register to view this content.
Does anyone see what I am doing wrong here?
Last edited by manofcheese; 06-05-2015 at 11:59 AM.
Syntax looks OK, would need to see more context. Also what error you are getting?
I am running into a Run-Time error 1004
I tried pulling out just that line into another module and then just put values instead of the variables as well as changing the sheets to their actual sheet names but I am still getting an error.
Ok, would need to see example code and workbook to try to troubleshoot it, because like I said, the syntax of that one line looks ok.
As an example, this works as expected for me.:
Please Login or Register to view this content.
Basically the only other difference is that my code is setting the ranges from different tabs to each other. An example could be
I just tried this line of code in a new workbook and it didn't work either.Please Login or Register to view this content.
I figured it out. To do it you need it to be something like this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks