xlf QandA series


WS VBA range array comparison


QUESTION

WHAT IS THE DIFFERENCE BETWEEN A RANGE AND AN ARRAY IN BOTH EXCEL AND VBA?


Answer icon Answer

1. Excel


Includes additional ideas!


1.1 Excel range


1.2 Excel array


2. VBA


2.1 VBA range


2.2 VBA array


3. Mixed WS VBA range array