VBA Macro Referencing

Questions ArchiveCategory: QuestionsVBA Macro Referencing
Daniel asked 2 years ago

Hello I had a question, that I can’t seem to find. The question is what are the steps to have cell referencing for macros on excel, currently on a MAC excel. If not is their specific code I can get to reference. Thanks.

1 Answers
Tyler Smith answered 2 years ago

In VBA, there are two ways to reference a cell. I’ll reference cell A1 and activate it by way of example to show the two ways:

  1. Range(“A1”).Activate
  2. Cells(1,1).Activate

Hopefully this answers your question.

Your Answer

3 + 0 =