active row

I found a really wonderful vba from alansidman - "Go to cell in specific column of the active row" (see below) Sub JumpToFront() Dim r As Long r = ActiveCell.Row Range("U" & r).Select End Sub But I need some code which goes to the very last column in the active row (not the...

Hello, Could you please help me with one macro for excel? I think that it is easy, but I can't find the effective solution. I have very big excel sheet where is many columns and I make similar operation many time per day, so I'm looking for the macro solution. I need macro, which will on...

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

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.

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 Cells(RR.Row...