last active row

  1. W

    Macro to Find Last Cell in Column and Use that Cell to Fill in Formula Row of Other Columns

    Hello! I've searched for something similar to this and have not had much luck. I apologize if it is an easy(ier) answer and I am just missing it. I have a data set that I download, export, and format multi times weekly. The data set is 125 columns by usually around 45,000 rows. The number of...
  2. E

    Compare last cell values in two columns

    Hi Excel gurus, I'm struggling to find a solution for this (via VBA), but is it possible to compare the last two cells in 2 columns for example, column A has 50 cells populate (A1-A50) however column B has 5 populated, is it possible to highlight this discrepancy? i.e the count of active cells...
  3. M

    VBA Compile error - Object required but everything looks right ...

    I've been using VBA (and this message board) on and off for years. The majority of the time I find I don't need to post because somebody has already asked and answered the question; but this time I'm truly stumped. I tend to modularize the majority of my code to make troubleshooting easy and...
  4. M

    VBA - Copy/Paste last value in column if the next cell is empty

    HI I need to copy the last value in the column every month and copy paste it into another document which shows the KPI for the current month. So if you look up the picture i need all the values from mar2021 to be copied this month and apr2021 next month. Is it possible to make some kind of VBA...
  5. C

    VBA Loop - duplicate header copied over

    I am wanting this code to loop through various files in a folder and copy info from each file and paste to a master file - my issue is that after it opens the first file and moves on to the second one, it will paste the header in there as well. All data starts on the same cells "A5" in all the...
  6. U

    How to find last row and Add A Border

    Hello Guys, I have workbook with Sheets 1 to 10. For each sheet, I need to find the last row, delete the excess vertical lines below it (just CTRL+DELETE). Below the last row, I need to add a vertical border by just copying the border that can be found on A3-AC3 across all sheets. Thanks in...
  7. S

    Lope Autofill Macro through all sheets

    This code is SOOOOO close to being right, but I cannot for the life of me figure out what I am missing. The part where I autofill the formula to the last row only works on the first sheet and not the rest. I'm sure its something dumb that I'm missing because I am new to the last row function...
  8. C

    VBA Pasting/looping

    I have a vba code to get info from multiple workbooks then paste them consecutively in one worksheet. I want the macro to paste to cell A1 everytime i run the macro, after clearing contents of the previous time i ran it of course. But instead it pastes to the last cell used from the last time i...
  9. E

    Autofill to the Bottom of the existing Data

    Hey guys. I have one more for the experts. I'm trying to create a macro that will find a location, input an equation, and autofill that equation to the bottom of the existing data. I tried recording the macro and using the double click feature, but when I was done, it didn't create a variable to...
  10. R

    Selecting last row after the row having some data

    Hi All, I would like to select a row after the last active row in the excel sheet. for example: imagine I have data till a row say 151 and i would like to select row 152. the number of rows in my worksheet always varies. Thanks, Raj
  11. D

    Locate Last Row and use the corresponding row number to define a Range

    I'm having trouble with the task of writing the code inside a macro to perform the task of locating the last active row of data on an open spreadsheet and then using the corresponding row number to define the Range of A10:Zxx A10 is the beginning row/column cell and Z is a known last column...
  12. J

    Finding last used cell

    I have a macro that when its run it opens another workbook and selects specific data, based on conditions someone has on the original sheet, then copies the data to paste onto the original sheet. I have a code that works but when I try to reference the last cell on the sheet I am opening it...
  13. J

    Take last active Row

    Hello, I am wondering how I can configure the code below so that only the active rows (those with data in them) will be copied into the new workbook. Any suggestions? Private Sub CommandButton1_Click()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

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