active row

  1. Z

    Shift range of cells on active row left or right

    Hi all, I'm having a bit of a nightmare here. I have what is essentially a planner: First five columns are static data and then I have thirteen empty columns. After that I have a number of hours per week for the entire year, and then another thirteen empty columns, and calculation columns after...
  2. J

    VBA Select active rows

    I want to select all the active rows in my spreadsheet starting with row 4. Columns A-I are populated. This is what i have so far, but it's wrong: ActiveSheet.Range ("A4:I" & Range("A" & Rows.Count).End(xlUp).Select) Thanks.
  3. D


    Hi Gurus, :-D This is my first post so if I'm not playing by the rules, I'm happy to take on any feedback... So I have a code that I use frequently that I want to place in my "personal macro workbook" so I can call it quickly without re-writing it each time I wish to use it. The code...
  4. P

    HELP PLEASE!!! How to delete applied format after navagating to different row

    I want to have the macro delete the color applied once a new "Row" is selected! Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim RR As Range Set RR = Target Cells(RR.Row, 2).Interior.ColorIndex = 36 Cells(RR.Row, 3).Interior.ColorIndex = 36 Cells(RR.Row...

Some videos you may like

This Week's Hot Topics