Help With Copy Formula Down Macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Help With Copy Formula Down Macro

FAQ

Thread Tools

Display Modes

03-04-2016, 11:53 PM

cobbe

Windows 10 Help With Copy Formula Down Macro

Office 2016

Novice

Join Date: Mar 2016

Posts: 6

Code:

Sub CopytoLast()
Dim LastRow As Long
 Columns("F").ClearContents
  LastRow = Cells(Rows.Count, "E").End(xlUp).Row
   Range("F2").Formula = "=CONCATENATE(A2,"" "", D2, "" "", E2)"
    Range("F2").AutoFill Destination:=Range("F2:F" & LastRow)
End Sub

K.r., Cobbe

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:	udhaya	Excel Programming	1	11-12-2015 10:12 AM
Question about Index match formula to copy all of cells in row	dmcg9760	Excel	1	11-08-2015 01:41 AM
Macro to copy formula from one cell to another	anwar	Excel Programming	1	04-25-2014 08:27 PM
Use formula to copy cell formats also	mike_abc	Excel	10	12-10-2011 01:55 AM
Excel copy formula	KMS	Excel	1	08-16-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.