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