Quote:
Originally Posted by macropod
Splitting the document into multiple files won't help unless you also start multiple independent Word sessions.
|
Sure. I don't like the rise of multi-core processors in recent years. Only a fraction of the end-user applications support this, but fortunately Excel is one of them. For Server it's clear, there's something in it.
Quote:
Originally Posted by macropod
In that case, there's more than just -1 in the cells (e.g. some spaces). You might try changing:
Split(.Range.Text, vbCr)(0)
to:
Trim(Split(.Range.Text, vbCr)(0))
|
Thanks, let me try. Maybe that's why I used Val() I think. What do you think about replace and removing my undo buffer?
Edit:
Didn't work. I'm still having many "-1". I've changed it back to "Val(.Range.Text) = -1". This works safe in my case.