vba to Add comma after 2 digit of time stamp in B:B col untill end of A:A last row value

[MicroTees]

Dear experts


I need help on vba code

I have run code to add comma after 2 digit but it take too much time to finish b85000 so i want run code depends upon end of last row of A:A col

assign the sheet name in the code also so helpful it can run from any sheet

Sub AddComma()

Dim jesus As Long

jesus = Cells(Rows.Count, "a").End(xlUp).Row

Application.ScreenUpdating = False

Dim cell As Range
For Each cell In Range("b2:b85000")
If cell.Value <> "" Then
cell.Value = Left(cell, Len(cell) - 2) & ":" & Right(cell, 2)
Else
End If

Next cell

End Sub

[JieJenn]

Here's a crazy idea. Cant' you just replace : with :: ?

Please Login or Register  to view this content.

[MicroTees]

Its doesnt work..Dude any experts pls help on this?

[jindon]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Try this

Please Login or Register  to view this content.

[MicroTees]

Sorry Dude I made mistake of explanation You were right at first code? Solved thanks for being time spend