-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
mylastrow
-
K
LastRow Code Debug + Copy Formula in last row
Hello, wondering if someone can help me. I have put together the below code but not sure why it isn't working. I am trying to copy my formulas in range B8:F8, to all the way down to the last row - this last row number is calculated from the data in another sheet. So e.g. in the School Payment...- khlau
- Thread
- copy mylastrow payment row sheet
- Replies: 4
- Forum: Excel Questions
-
T
VBA code - forgotten how to do this
In column G are a list of Order Numbers In my macro I'm using "mylastrow" to identify the end of the data so in mylastrow +1 I need formula =min(G2:G & mylastrow + 1) then below =max(G2:G & mylastrow + 2) So simple but.....- Titian
- Thread
- =ming2g data end identify mylastrow
- Replies: 3
- Forum: Excel Questions
-
S
Looping problem -
Greetings Experts, I'm trying to look at the value of a cell in a range. In this case, the range is range("AK2", range("AK" & myLastRow) If the cell contains "L" input =IF(AL2=AJ2,TRUE, FALSE)) - 3 cells down (in "AN2") if the cell contains "KG" input...- Sphinx404
- Thread
- loop 2 ranges mycell mylastrow range
- Replies: 6
- Forum: Excel Questions
-
H
VBA Inserting/Deleting rows
Hello, I have set up the following code in VBA to insert rows into my table. Here is the code Dim myLastRow As Long myLastRow = Worksheets("Before n After Remap Review").Range("A7").End(xlDown).Row MsgBox prompt:="The last row is Row No. " & myLastRow Dim x As...- HazatB
- Thread
- code dim mylastrow row rows
- Replies: 4
- Forum: Excel Questions
