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
Hi Jason,
One way of speeding this up is to use:
Application.ScreenUpdating=False
at the beginning of your code.
(And don't forget the Application.ScreenUpdating=True at the end.)
But I'm sure we could speed it up in other ways as well.
Any chance of attaching the file, or a sample file?
Reg
