Help needed to writing a macro to put the year in column B of a table using Table nomenclature & the Evaluate method
Hi Bob,
Am Fri, 26 Dec 2014 12:47:00 -0500 schrieb BobbyBenj:
- Solution3 took 1.70873559481424 seconds to process 100,000 dates
- Solution2 took 3.29125182459939 seconds to process 100,000 dates
- Solution1 took 1.53838717548297 seconds to process 100,000 dates
try Solution4:
Sub Solution4()
Dim LRow As Long
Dim myRng As Range
Application.ScreenUpdating = False
LRow = Cells(Rows.Count, 1).End(xlUp).Row
Set myRng = Range("B2:B" & LRow)
With myRng
.Value = myRng.Offset(, -1).Value
.NumberFormat = "YY"
End With
Application.ScreenUpdating = True
End Sub
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|