last active row

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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>...

Some videos you may like

This Week's Hot Topics