Excel - Get Single Cell vs Get Multiple Cells vs Get All Cells
I experimenting with AA and I get the difference between the three types of "Get Cell" commands, it seems a little easier when working with lots of data to get each single cell and save it to a variable versus Get Multiple Cells or Get All Cells. If I want to do something with the data, I have to save each data to a variable anyway so why use the other commands. Plus, if I use the Get All Cells doesn't it eat up memory. Can anyone provide some basic insight as to when to use each command and how. I ask how because there are various system variables like excel cell column, excel cell row, excel column that can be used with these commands that can also be confusing. Appreciate the insight.