VBA: Sheet code name - compile error?

[botanist]

Hi there! I am currently attending an online beginner's VBA course (completely new, so please pardon me here!), and am trying to reference sheets using their code names.

I have written the following code (Office 365), but am getting the "Compile Error: Variable not defined" error when trying to run it. Would anyone know why this is so?

Sheet5.Range("A4").CurrentRegion.Copy Sheet6.Range("A4")

Thank you so much for your help in advance!

 

[YasserKhalil]

Make sure that you have worksheet code names Sheet5 and Sheet6

 

[botanist]

Hi there, yes, my worksheet code names are Sheet5 and Sheet6 - the default; have not made any changes. Not sure what the issue is !

 

[RoryA]

If you're getting that error on that line, then either the code names are different, or those sheets are in a different workbook to the code.

 

[botanist]

THANK YOU SO MUCH, RoryA! Solved!

 

[RoryA]

Glad we could help. So... which one was it?

 

[botanist]

I had the module built under my Personal Workbook, rather than the Excel workbook I was working on. All prior codes worked well as there was no references to specific sheets until now.

Thanks so much again! Just beginning my VBA journey, and am so excited!

 

[RoryA]

Just beginning my VBA journey

It's an interesting ride.