Dynamic Cell Address Construction

  • Thread starter Thread starter desktopbbb
  • Start date Start date
D

desktopbbb

If cell A1="B" and cell A2 = "1", is there a way to construct the
address B1 by combining the contents in A1 and A2 so that address B1
can be used in a formula ? If yes, does it mean that a range address
can be constructed in the same way ?
 
Back
Top