how to continue formula in below line in vba code how to continue formula in below line in vba code how to continue formula in below line in vba code

The solution for “how to continue formula in below line in vba code how to continue formula in below line in vba code how to continue formula in below line in vba code” can be found here. The following code will assist you in solving the problem.

Get the Code! 
Range(“tablename[columnname]”).Formula = “=G3&””,””&L3″Sub CopyDown()

Dim Lastrow As String, FirstRow As String, strtCell As Range

‘

‘ CopyDown Macro

‘ Copies the current cell to any empty cells below it.

‘

‘ Keyboard Shortcut: Ctrl+Shift+D

‘

    Set strtCell = ActiveCell

    FirstRow = strtCell.Address

‘ Lastrow is address of the *list* of empty cells

    Lastrow = Range(Selection, Selection.End(xlDown).Offset(-1, 0)).Address

‘   MsgBox Lastrow

    Range(Lastrow).Formula = strtCell.Formula


    Range(Lastrow).End(xlDown).Select

 End SubRange(“$M$3”).Formula = Range(“G3”) & (“,”) & Range(“L3”)


Dim Lastrow As Long


Application.ScreenUpdating = False


Lastrow = Range(“L” & Rows.Count).End(xlUp).Row

Range(“M4”).FormulaR1C1 = Range(“G4”) & (“,”) & Range(“L4”)

Range(“M4”).AutoFill Destination:=Range(“M4:M” & Lastrow)

ActiveSheet.AutoFilterMode = False

Application.ScreenUpdating = True

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

do while in vb

Bym0nxt3r

The solution for “do while in vb” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]