More Efficient way of updating data?

[nironto]

Hi All,
I am trying to update a column but this method is very slow if we are dealing with 50k of records.
Is there a better way of doing it?

If ActualV = "Car" Then Range("B" & X).Value = "Yes"
If ActualV = "Plane" Then Range("B" & X).Value = "Yes"
If ActualV = "Motorbike" Then Range("B" & X).Value = "Yes"
If ActualV = "Yacht" Then Range("B" & X).Value = "Yes"
If ActualV = "Trishaw" Then Range("B" & X).Value = "Yes"


Thanks!
Nironto

[Crooza]

Is this any quicker?

Please Login or Register  to view this content.

[Crooza]

double post !!!

[jindon]

Try

Please Login or Register  to view this content.

[nironto]

Hi Crooza,
I checked that I only posted once. Your solution does help but not much improvement.

Regards,
Nironto

[nironto]

Thanks Jindon!
This is what I need! Time taken is reduced from 3 mins to 10s!

Regards,
Nironto

[Crooza]

I checked that I only posted once.

No mate. My post was duplicated. An idiosyncrasy of this website. I edited the second post out and explained it away as a double post.