What is the difference between ActiveCell and Cell In VBA?

Questions ArchiveCategory: ProgrammingWhat is the difference between ActiveCell and Cell In VBA?
Calvin Schofield asked 2 years ago

I was trying to work ahead in the Burgers example and then check my work with what Professor Gaskin did to see how I was understanding concepts so far, and ran into the problem of ActiveCell not working as I had anticipated. Rather, Professor Gaskin used “Cell” instead of ActiveCell. What are the core differences between the two and how can I know which to use in order to have my code run successfully?
 

1 Answers
Calvin Schofield answered 2 years ago

never mind…again! \”cell\” in this example was the variable of type Range used to loop through each restaurant in the list! makes sense  
 

Your Answer

16 + 19 =

css.php