-
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.
lastrow.formular1c1
-
VBA apparently won't wait until the previous formula is completed
I've created a macro that's supposed to: 1. get the account numbers from another sheet, together with their transactions 2. de-duplicate account numbers 3. calculate the number their transactions, dependent on the transaction status (pass, review, reject) 4. allocate customers to the sales...- fraudit
- Thread
- de-duplicate lastrow lastrow.formular1c1 runs transactions
- Replies: 4
- Forum: Excel Questions
-
Code based on condition of a Checkbox
I have a checkbox1 I only want the code to run of the box is checked. (And have a message box if its not checked.) How do I put that If statement in? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ' Dim LastRow As Long ' LastRow =...- gheyman
- Thread
- ind lastrow lastrow.formular1c1 lastrow.value ranged9d
- Replies: 3
- Forum: Excel Questions
-
D
Help with VBA
Hi, I am currently using a Vlookup but the problem is the static columns and my columns will change from time to time. Sub Update() Dim LastRow As Long LastRow = Range("A" & Rows.Count).End(xlUp).row Application.ScreenUpdating = False Range("I2:I" & LastRow).FormulaR1C1 =...- decadence
- Thread
- cell columns header1 lastrow.formular1c1 row
- Replies: 3
- Forum: Excel Questions
