Fill a column with a formula up to an empty adjacent cell

**dburge07** · 06-25-2021, 02:09 PM

So i'm trying to apply =Left(B2,4) to a static range that changes daily. How can I apply the formula up to the first empty row of Column B?

Sample workbook attached.

Thanks!

**cubangt** · 06-25-2021, 02:16 PM

You can do something like i do in my report


Private Sub AddUpdateDaysFormula()
    
    Dim LastRow As Long
    ' THIS GET A TOTAL COUNT OF ROWS BASED ON CLAIM NUMBER
    LastRow = ThisWorkbook.Worksheets("Cleanup").Range("A" & Rows.Count).End(xlUp).Row
    ThisWorkbook.Worksheets("Cleanup").Range("K2").FormulaR1C1 = "=DAYS(TODAY(),RC[-8])"
    ThisWorkbook.Worksheets("Cleanup").Range("K2").AutoFill Destination:=ThisWorkbook.Worksheets("Cleanup").Range("K2:K" & LastRow)
    
End Sub

**Artik** · 06-25-2021, 02:18 PM

Try this

Sub AAA()
  Dim lRow As Long
  
  lRow = Cells(Rows.Count, "B").End(xlUp).Row
  
  Range("A2:A" & lRow).FormulaR1C1 = "=LEFT(RC[1],4)"
End Sub

Artik

**davesexcel** · 06-25-2021, 02:31 PM

Short and sweet!

Range("A2:A" & Cells(Rows.Count, "B").End(xlUp).Row) = "=LEFT(B2,4)"

Fill a column with a formula up to an empty adjacent cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Fill a column with a formula up to an empty adjacent cell

Re: Fill a column with a formula up to an empty adjacent cell

Re: Fill a column with a formula up to an empty adjacent cell

Re: Fill a column with a formula up to an empty adjacent cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find first empty cell and fill in formula too the last row of data in another column

Count column value then adjacent column cell fill color

How to fill the values in the adjacent columns if the column is not empty

How to Populate an Empty Cell with Values from Adjacent Same Record But Different Column

[SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.

[SOLVED] Fill Formula up to last empty adjacent Column

Fill empty cells per adjacent column

Bookmarks

Bookmarks

Posting Permissions