Why add Cancel As Boolean and EntireColumn when hide some columns before printing?

Hello,
I see these codes in my book:

Please Login or Register  to view this content.

but I am questioned about two things:

1. Why add Cancel As Boolean on the first row?
2. Why add EntireColumn before Hidden

It didn't use Cancel at all and Range("B:D") are three columns exactly.
Thanks.

I still don't understand.
1. How can I cancel it? I tested it and didn't find any button of Cancel.
2. What is the difference between columns("B:D") and Range("B:D")?

1. See this page for more info
https://learn.microsoft.com/en-us/of...ok.beforeprint

2. Using columns(..), you already refer to the columns. If you use Range(..), you need to call entirecolumn before you can refer to the column. But, I see your confusion.

Thanks. But didn't Range("B:D") refers to columns("B:D")? If it didn't, what else did it refers to?

Yes it does, but you can not just use .hidden after Range(..)

But I see the 'Hidden' is one of the members of 'Range'. Why can't I use it after Range(..)?

Because you can’t hide a range.
Just the entire rows or columns of that range

But why 'Hidden' is one of the members of 'Range'?Attachment 805814