Question

Which of these changes would make the following section of code scalable if additional data was added to a file?

ActiveSheet.Sort.SortFields.Add Key:=Range("B1:B265") _

A. Change the range "B1:B265" to "B:B"

B. Change the range "B1:B265" to "A1:Z265"

C. Change "ActiveSheet" to "ActiveAllSheet"

D. All of the above

​

Answer 1

Answer:

D . All of the above is the answer