View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
persenena persenena is offline
external usenet poster
 
Posts: 1
Default Excel vba script extremely slow


Hello

I have strange problem with this vba script
Values in cells are numeric or string like 1, a2, aa, 3 etc.
Each loop takes ~10sec on 2.5 GHz Pentium


Code
-------------------

Dim column As Integer
Dim row As Integer
Dim value As String
Application.ScreenUpdating = False
For column = 4 To 44
value = Cells(row,column ).Value
MsgBox (value)
Next sarake
Application.ScreenUpdating = True

-------------------


Any suggestions on how to make it run faster ?

Nevermind I got it workin :D stupid m

--
persenen
-----------------------------------------------------------------------
persenena's Profile: http://www.excelforum.com/member.php...fo&userid=2491
View this thread: http://www.excelforum.com/showthread.php?threadid=38448