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

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top