Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can anyone tell me why this piece of code is taking over five minutes to
execute. I actually don't know the total time it takes because I keep giving up after waiting about five minutes... For Each cell In Range("B7:K500") Do While Left(cell.Value, 1) = "," cell.Value = Right(cell.Value, Len(cell.Value) - 1) Loop Next If anyone could tell me a more efficient way to write the code I would appreciate it. This is a small part of a larger macro that I would like to run in under one minute. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Mintues | Excel Worksheet Functions | |||
Can you automaticaly save a shared file every few mintues? | Excel Discussion (Misc queries) | |||
Execute C++ from Excel | New Users to Excel | |||
how to I add running hours & mintues in Excel | Excel Discussion (Misc queries) | |||
Could not execute | Excel Worksheet Functions |