I'm trying to get the basics of the objects, properties, and methods down, but can't find any great online resources. In the meantime, I guess actual examples is the best way to go. I have some code that I got from one of the experts here in a previous question (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26856102.html
). The problem was, in the example I provided, the data was on the same page, when I'm actually linking to and importing from an Access database onto a separate Sheet I call "QB_Expenses". I'm trying to walk through the code so I can learn and adjust. My first sticking point is:
lastRow = Range("A" & Rows.Count).End(xlUp).Row
how do I change that so that I'm finding the last row on the QB_Expenses sheet instead of the current sheet?