final row

  1. L

    Macro to autofill cells based on last cell or final row data in adjacent column

    I'm trying to create some automation in a macro--see attached picture. The automation includes adding a formula in cell G2 =CONCATENATE($F2,"")--then autofill this formula down column G to the last cell or final row in column F. I don't know how to reference the adjacent column when...
  2. V

    Borders Around Cell Fill Down

    This forum has been wonderful helping me learn about macros and vba. I come back to the group to see if I can get assistance on how to fill down a border to the last row. On a pre-designed template with the All Borders around each cell beginning row 6 - row 27 to column H. My macro brings data...
  3. E

    Finding Last Row in Column

    Hello, I'm new to VBA and I'm having a little difficulty with a loop that is running to the end of worksheet instead of stopping at the last row in the column. The second row of the code here seems to be the culprit. Any help is appreciated. Thanks. Sub LTM() FinalRow = Cells(Rows.Count...
  4. B

    VBA - Use FinalRow value in SUMIF formula

    Hello, <o:p></o:p> <o:p></o:p> Can someone please help with the syntax to use VBA for including FinalRow value in a SUMIF formula? Hope this is on the right track. The goal is to keep the formula available in the cell after running the macro.<o:p></o:p> <o:p> </o:p> <o:p></o:p> 'Determine Last...
  5. P

    Find multiple entries

    Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...
  6. C

    What am I Doing Wrong??

    So I am trying to find the end of a column and input an if statment withing those 70 something cells. Below is my script any ideas?? FinalRow = Cells(Rows.Count, 2).End(xlUp).Row Range("A2" & FinalRow).Formula = "=if(F2="","", Today())" Range("A2").Copy Destination:=Range("A2" &...
  7. R

    Code from Bill Jelen book gens error

    I've copied and pasted from Bill's book "VBA and Macros for MS Office Excel 2007", tried typing etc. but continue to get an error... This is supposed to select the final row in the data list... Error is "Compile Error. Expected Function or Variable." I thought "FinalRow" was a variable...

Some videos you may like

This Week's Hot Topics