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

    Calling

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top