final row

Hi all, I have the below data, in column L: COLUMN L 1 2 3 AADDYE 4 FJGLLT 5 FJJDUE 6 FJGOTR 7 ADREWS 8 FSERTT 9 MBJGFR 10 FKOORR I want the output as per below when I run the marco to be: "AADDYE","FLGLLT","FJJDUE", - looping until the final data...

I'm trying to create some automation in a macro--see attached picture. The automation includes adding a formula in cell G2 =CONCATENATE($F2,"@gmail.com")--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...

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...

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...

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...

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...

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" &...

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...