Forum Discussion
katrina bethea
Nov 02, 2018Brass Contributor
using VBA to select first empty row.
I am teaching myself how to work all aspects of excel (formulas, Macros/VBA, ect) on my own with no books and online free resources only. I say this because some of my questions may have an obvious f...
katrina bethea
Nov 05, 2018Brass Contributor
I know very little about programming in any language. I tried putting this into the code/macro and still got an compile error. Where am i supposed to put this code? The VBA editor you mentioned, is that the same thing that you go to when you click the "step into" function on a macro?
I get the concept, basically creating and setting up a new word within the VBA database right?
Wyn Hopkins
Nov 06, 2018MVP
... yep the VBA Editor is the place you go when you click Step Into. The keyboard shortcut is Alt+F11
- katrina betheaNov 06, 2018Brass Contributor
Thank you. I read your article and i have a book on the way but have not received it yet.
- Wyn HopkinsNov 06, 2018MVPGreat, let me know if the code works
- katrina betheaNov 07, 2018Brass Contributor
WORKED GREAT. HAD TO TAKE OUT THE "PASTE VALUES" PART THOUGH SINCE I NEEDED FORMATS COPIED TOO BUT THAT ONE WASN'T A HARD ONE TO FIGURE OUT. THANK YOU AGAIN