visyouall
01-25-2016, 10:29 AM
I am new to Excel VBA. I have been given a large Excel file with several macros and I am tracing the code flow. My understanding of this code:
Worksheets("ABC").Activate
Range("abc_name").Select
is that the sheet ABC should get the focus and that some range on this sheet must already have been already named "abc_name" somewhere in the code. However, I cannot find the string "abc_name" anywhere in any of the modules that affect this workbook.
Advice is appreciated.
Worksheets("ABC").Activate
Range("abc_name").Select
is that the sheet ABC should get the focus and that some range on this sheet must already have been already named "abc_name" somewhere in the code. However, I cannot find the string "abc_name" anywhere in any of the modules that affect this workbook.
Advice is appreciated.