• 0 Posts
  • 15 Comments
Joined 1 year ago
cake
Cake day: March 5th, 2024

help-circle

  • I cannot imagine that a significant percentage of Excel power users care what column number ABC is. You use either A1 notation or R1C1 notation based on your need. You don’t have to convert between the two. You can even use the INDIRECT() function to reference a cell either way regardless of your general settings. In VBA, you can use Range(“A1”) or Cells(1,1) to reference cells with either notation. Either are always options. Conversion is not necessary.