Better Worksheet References in VBA for Excel

[@querrythis]

Very explicit. Great simple example. Thanks

[@rohanarora2316]

Hey, I want to use a formula of sumif in 1st sheet containing the sum from 2nd sheet and 3rd sheet together and name for these sheets keep changing can you help me out.

[@ruibarata6581]

Hello everyone, If I have two or more VBAProjects open simultaneously, how can I choose or indicates whit the VBA, what the workbook sheet select? Example: I have two or more workbooks with the same Sheet names, Sheet1, Sheet2, ... etc. How do I code it, to give the correct path to go to Sheet1 of a specific workbook name? Thank you very much for your help!

[@wayneedmondson1065]

Great lesson! Thanks for sharing. Thumbs up!!

[@nadermounir8228]

Nice tutorial. Thank you for your hard work 👍

[@janezklun]

Good one, thank you for sharing

[@Weehawk]

Thanks you senpai

[@Rockefeller.69]

tyty

[@jerrygarland4240]

Good useful stuff. (pet peeve: learn the proper pronunciation of the word Data. 😊)

[@timbrykkk]

Key thing I need is that you cannot use codenames to reference sheets in other workbooks.