Better Worksheet References in VBA for Excel 

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.

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!

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

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

Very explicit. Great simple example. Thanks

Great lesson! Thanks for sharing. Thumbs up!!

Nice tutorial. Thank you for your hard work 👍

Good one, thank you for sharing

Thanks you senpai