sorry guys, simple question and I must be stupid, literally. here's what I have:
nothing is being copied from book to book in the above code. all objects are set just fine, all variables have the vals they need to have. I've tried everything I can think of to get the code to recognize I want the row data copied from one book and pasted in a row in another book. I've tried to activate anything I can think of. all of the following tricks I've tried, and nothing happens with these either (included in the below attempts is some code that I got from the macro recorder too, which doesn't make sense whatsoever):
trying to activate the worksheets before copying
trying to activate the workBOOKS before copying
trying to SELECT the data before copying and before pasting
what in the world am I doing wrong here guys? I would think that one of these attempts would work!
Bookmarks