In following video I will show an Excel VBA macro example about how to loop through each selected cells and write location information to cells.
We can use Excel’s Selection object (Range type containing selected cells of the active worksheet) and cycle through selected cells by using For-Each-Next loop:
For Each c in Selection ... c.Value = ... ... Next
c stands for single cell (Range type).
Following video clarifies this.