13.select

  1. R

    VBA Question about Skipping Rows - HELPppppp

    I have a row count of 13 Can I skip rows 7 & 8? How would I code that up in Visual basic? Sub Worksheet_Activate() rowcount = ActiveSheet.UsedRange.Rows.Count Range(Cells(9, 1), Cells(rowcount, 13)).Select Selection.Sort Key1:=Range("F9"), Order1:=xlAscending, _...

Some videos you may like

This Week's Hot Topics

Top