Speed up a macro...

Hi all,

So below is the code i use to convert column B from yyyymmdd to mm/dd/yyyy:

Please Login or Register  to view this content.

I have to do this for 6000 lines and this is taking way to long. I have "Application.ScreenUpdating = False" at the start is there anything else i can do to speed it up?

Thank you

You mean doing this manually?

I have no problem doing this my self.... the problem is this is a big macro and process that i am streamlining. the code above is just one very small part of the macro. but it is the one that takes time.

How long is it taking you currently?

It doesn't seem like it should take a long time.

You can always record the process that Norie posted and incorporate that into your macro. And I've found looping through ranges using the collection is slower than using a numeric variable to step through row numbers.

10 to 15 min.

So my other question is there a way i could filter column B with the date as it is yyyymmdd vs. changing the column then using:

Please Login or Register  to view this content.

Larai.... you talking way over my head.... Not a very good writer.

Why not perform your date calculation, change the calculated date to yyyymmdd and set your filter accordingly?
strFilter = format(date()-180,"yyyymmdd")
Criteria1:="<=" & strFilter

You might have to tweak a bit, I haven't tested it.

i'll give that i try... again...

Seams like that worked fine.. will need to run this live a few times... but Thank you Larai!!