asked on Excel 2010 VBA - When to use sheet1.something versus worksheets(1).something
What is the difference between using sheet1 and using worksheets(1).
They both refer to individual sheets in a workbook.
1. What are the features of each of these, and
2. why use them?
They both refer to individual sheets in a workbook.
1. What are the features of each of these, and
2. why use them?
Microsoft ExcelVBA
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
sheet1. brings up the intellisense whereas worksheets(1). does not
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Great insight. Thanks to all!
you're welcome ~ happy to help