hey all, i have the follwing VBA that i'e written, but i think i've messed it up...
Sub Insert_formula6()
Dim Cell As Range
Dim InputValue As String
On Error Resume Next
ActiveWorkbook.Sheet2.Activate
lastRow = Sheet2.Range("A" & Rows.Count).End(xlUp).Row...