Invoices and invoice Register

[LesHunter]

Hi, I have just become involved in VBA and macros
Its a new Challenge in my retirement
I have followed to the letter the VBA code shown in you You Tube Posting [h=1]Learn Excel - Create an Invoice Register - Podcast 1808[/h]Finding it extremely helpful However when I compile it I get error messages
The part I'm having trouble with is the PostToRegister Macro
line 10 Variable not defined.
NextRow = WS3.Cells(Rows.Count, 1).End(xlUp).Row + 1
I didn't see any errors occur on the Video so may be its my version of Excel
Which is 2016

many thanks in anticipation
les hunter

 

[Fluff]

Glad it's all sorted

ps I'm an egg chaser, hence the avatar