a1 notation

  1. J

    Column() convert to letter (A1 notation)

    Is there a way to get the column letter (in A1 notation) of the active cell, as opposed to its number (from R1C1 notation). =ADDRESS(5,10,4 ) returns row and col in A1 notation, but getting just col is a parse job My sources of column number (R1C1) Formula: =Column() Code: MsgBOx("active...
  2. O

    building forumlas in excel

    I have this code: While Not (IsEmpty(Selection)) pointer.Offset(0, 1).Formula = pointer.Offset(0, 1).Formula & "+sumif('" & sourcesheet & "'!" & chr(columnfinder)+64 & ":" & chr(columnfinder)+64 & "," & pointer.Value & ",'" & sourcesheet & "'!" & chr(Selection.Value)+64 & ":" &...

Some videos you may like

This Week's Hot Topics

Top