![]() ![]() ![]() This line of code references Sheet1 of the active workbook even if Sheet2 is the active sheet. ![]() To avoid this, refer to a sheet that is not active by first referencing the Worksheet object: Worksheets("Sheet1").Range("A1") Switching between sheets by activating the needed sheet slows down your code. MrExcel ® is a registered trademark of Tickling Keys, Inc.Īll contents © 1998 - 2022 MrExcel Publishing | All rights reserved.Learn More Buy Referencing Ranges in Other Sheets View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |