lastcol2

  1. gheyman

    Copy Down to last Row

    How Do I get the formula to go down to the last Row? lastrow = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row lastcol = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column + 1 'after last populated col lastcol2 =...
  2. jbesclapez

    Trying to insert a variable in a INDEX formula in VBA

    Hello, I have this code working. Range("A2").Select Selection.FormulaArray = _...

Some videos you may like

This Week's Hot Topics

Top