Recent content by jshep120

That worked wonderfully, I thank you! I ended up using i = 2 .Range("A2").EntireRow.Insert to insert a new row and now everything is Bristol. I appreciate all of your assistance.

Thanks, JHB. That definitely worked. However I am still running into the issue wherein after 2 records are exported to the appropriate sheet (the setFocus line of code assures this) the third simply overwrites the second rather than continue to populate the table in the sheet. And the records...

Good morning all, I have been attempting to write a rather complicated (for me at least) VBA code that exports data from fields in an Access Form to an Excel Spreadsheet. The form has many entries, as such my ultimate goal is to be able to navigate to each record, click the event button and have...