Excel hangs when getting text from cell

[DarkAnima]

Hello - if I read integers from cells using, for example, myInteger = Cells(5, "C).Value, my code runs fine.....

....if I try to read in a string, using myString = Cells(5, "D).Value, Excel hangs every time!!?!?!?

Why does it work ok for integers but hangs for strings??

Any help greatly appreciated.

[sintek]

Surely .... you mean Cells(5, "C").Value

[DarkAnima]

Yep! (Typo)

[sintek]

K, let me try this again...
Hallo DarkAnima

Welcome to the Forum. We can surely solve this mystery....
How bout uploading a sample file so that we can see what we are working with...
i assume it has to do with .value and .text

[DarkAnima]

Here is my code that runs when the user presses the "Save" button - the line that is commented out causes Excel to hang for 4-5 seconds when uncommented!? The only difference between that Cells call and the other is that it's text not a number!!

Please Login or Register  to view this content.

[sintek]

Try changing this...

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

@ Winon...
Wat se jy maaitjie....Kan miskien verkeerd wees.

[jindon]

DarkAnima

Don't use text property, unless you really need to use it.
It will slow down the process and if the cell shows like #######, it will pick it as it is.

What is in Cells(5, "C")?