Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Assignment 1 VBA/Macro Course Compile Error


Im getting a compile error, invalid use of property on the very first assignment.

Sub ResetInvoice()

Range("headerRow", "subtotalRow").Resize (Range("subtotalRow").Row - Range("headerRow").Row - 1)

Thank you in advance for your help!



As John said, please use the contact link at the top of the page to message me. I can provide you direct personal support that way.
don (rep: 1989) May 4, '23 at 4:21 pm
Add to Discussion



Hi Shelley and welcome to the Forum.

Please note that if you have questions on the VBA course contents, please don't post them (or code/ files) here or elsewhere. Instead use the Contact link (in the green bar above) and use the Premium Courses option. Don will then answer you directly but allow him some time- he's a busy man!


Answer the Question

You must create an account to use the forum. Create an Account or Login