1. N

    The last LastRow problem

    Hi there. Looking for help with vb script that inserts data to 3 different worksheets using an userform with a commandbutton_click. Found a script (non AI) LastRow that works for the first worksheet (Guests), but for the other sheets Diver Details and Book and Travel it will put the entered data...
  2. A

    Lastrow in VBA no longer works with Table

    Hello all, I have a piece of VBA that identifies the last row in a column, so that I can assign values: Lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("A" & Lastrow).Offset(1, 1).Select BankNo = ActiveCell My issue, is I recently formatted the data on the worksheet as...
  3. WildBurrow

    Pasting select columns to another sheet using LastRow and Offset

    I've found code that will copy select data from (Sheet1) to another (Sheet2) ; using only values found in columns "B:E" and "I:K". Columns "I:K" will always have data on each row pasted on to Sheet 2. Columns "B:E" may not have data on each row. Code from Sheet1...
  4. M

    New problem - FinalRow based on two criteria?

    Hello and thanks for reading this! (I apologize for length, but want to be thorough so you don't have to try and read my mind. Good question = good answer right?) The code below works the first time through, but the code will be ran multiple times. It's a two step copy and paste based on...
  5. S

    VBA syntax error when trying to copy data from another workbook

    Hi all, I'm getting a syntax error when trying to run this. What I'm doing is: I have workbook open, then when I run vba it asks me to open another workbook, from which it copies from B4 until E last row in worksheet called balances. Then it pastes data in current workbook from A last row. A...
  6. V

    VBA code opening a new workbook and giving out put. how to fix it?

    Hi All, This is the code I am trying to execute. I am getting the result correctly. But my issue is instead of lastrow sheet in the same workbook macro creates a new workbook with a new sheet named as the last row and giving output there.. Why it's not giving the result in the same worksheet...
  7. V

    VBA to find any changes in lastrow

    Hi All, I am trying to find the last row using VBA in the table. I found the last row but my challenge is how to store that value and compare it with new last row. My aim is to if any changes in the last row, it will trigger a macro. Thanks in advance. Regards, Vigash
  8. U

    Finding last row of column not recognizing all rows in column

    Hello, I've created a workbook with 4 worksheets that have been copied from other workbooks. In this workbook I'm trying to copy and paste all data from a column in sheet1 to sheet2. I'm using the following vba code: Dim lastRow As Long lastRow = Cells(Rows.Count, 1).End(xlUp).Row...
  9. R

    Relative reference in the use of the formula left VBA

    I created this macro to count the number of rows starting from column B. Then I created a cycle to fill columns 3,4,5 and 6 with excel formulas. my problem is that the references should be relative and not absolute (b5,b6,b7 and c5, c6,c7...until the last line). I can't finish the macro. Can you...
  10. H

    Trying to set VBA range to last row with values--duplicate declaration error

    Hello, I'm creating an excel template with a formatting macro. The template will have data of varying length added to it (could be 10 rows, could be 1000). I created a macro using Record Macro, then added a section to add a border after each unique value in the last column. It's working great...
  11. G

    If cell has data, move down 1 row and paste

    Good morning, I have the following macro. I simply want it to look at A1 on the current worksheet, if that cell has data then move down to A2. Then the next time I important data it will look at A2 and paste in A3 etc. Not quite sure how to do this myself, any help is appreciated! Private...
  12. W

    Using last row in this code

    Hello, I have an excel database with about 50 unique sheets. The formatting of these sheets is the same in all cases but each worksheet is for a different supplier, some worksheets contain 10 rows, some 450+ I made an userform, to make it easier to add, edit, etc. the products listed on these...
  13. C

    VBA copy LEFT function / formula down all cells in column

    Hi guys! Long time reader, first time poster. Getting very frustrated with my VBA so any help is appreciated. In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H. My VBA code...
  14. A

    Add entry at the end of a list with a UserForm

    Hi guys, I am trying to write a code within a userform which can be used to enter data on 3 columns. The columns are F, G, H and the row start from row 4. But when I try to run the code I get an object error on ActiveSheet.Cells(lastrow + 1, 6).Value = TextBox1.Value. I'm new to VBA so the...
  15. U

    Copy Range of Cells And Paste Until Last Row

    Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?
  16. M

    Run macro on event

    Hi guys, I have the working code below, however when I try to added to run in a change event the Range with lastrow stops working, wondering if any of you can advice on what can I do? Sub field_change() Dim LastRow As Integer With ActiveSheet LastRow =...
  17. F

    Fill Uneven Records Across Columns

    Hi All, Could you please help me find a way to fill in the blank cells that should start from the LastRow + 1 in Col B and go until LastRow in Col C? At the moment the data is just being pasted over the lastrow in Col B. Loop in question is the last one, rest is just used to show more or less...
  18. R

    Finding Last Row/Column to Hide other Cells

    Hello, I am trying to finding the last row with a value. -I know how to do this typically by using "xlUp" but for some reason it is stopping at a cell that does not contain a value but just a change in color. -I am now trying to find a different way to go about this. Instead, I want to...
  19. E

    Formatting to last row

    I want to highlight cell b37 and until the last row (which might change) in order to format that range of data this is what i have so far, whereby i have declared at the very start of the code the following: Dim Lastrow as Long originally i had it as range("B37:B150").Select, but i had to...
  20. R

    Finding the last row that contains a value, of a column

    Hello, I am trying to select a cell in the last row that does not contain a 0. It is taking me to Row 54 but I want it to go to Row 37. The method I know is to go to a cell at the bottom of the sheet and "xlUp" so it will find the first value it finds. I want to do this but want to ignore all of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back