rng.row

Hi All, I am using the below code to create partition / applying borders in range A4:L4 down till the last non empty cell whenever a value changes in Column B. Sub Test() Dim LastRow As Long LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row...

Hi, I have written Function StopTime(Rng As Range) As String StopTime = Format(Range("D10") + TimeValue("00:0" & Range("RngMin")) * (Rng.Row - 9), "hh:mm") End Function that calculates nicely the stoping time based on amoung of lines (Rng.Row) times an interval in minutes found in...

Set rng = ("A1:A10") For i = rng.Row + Rows.Count - 1 To rng.Row Step -1 is it mean 11-1 to 10-1?

I need help. How to put cell wi.Sheets("Data Operação").Range("Q5") in the cell ThisWorkbook.Sheets.Range("P" & rngRow). If i add, the result equal "" but expected is 100: wi.Sheets("Data Operação").Range("Q5").Value = ThisWorkbook.Sheets.Range("P" & rngRow).Value My code

Hello all, I have this code that takes info from a cell and puts it in comments, but when it does, excel always needs to restart as a result of the systems resources getting used it and causing major lag. I was wondering if anybody could give me insight into what exactly causes this, and if...