Thanks you two, I integrated both suggestions into my vba and it
processed instantly. Very helpful :)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
HI,
Try out the following:
Sub trial()
Dim rng As Range
Dim what(9) As String
what(1) = "FD"
what(2) = "EX"
what(3) = "NA"
what(4) = "NB"
what(5) = "NC"
what(6) = "HN"
what(7) = "CLD"
what(8) = "Location"
what(9) = "of"
For i = 1 To 9
Do
Se
ample file?
Regards - Dave.
> Date: Tue, 6 Apr 2010 08:18:05 -0700
> Subject: $$Excel-Macros$$ Request Help to make code more efficient.
> From: jsin...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hello all fellow fellow Macro friends :)
>
> I have a short bit of
Hello all fellow fellow Macro friends :)
I have a short bit of code that I was wondering if it's possible to
make it run more efficiently. When it runs currently it takes up to 1
minute which seems like a long time.
Notes: This is designed to remove an entire row if the condition is
met. There is
