Out Of Resources Error

[jo15765]

Maybe my script is just incorrectly written, what I am wanting to do is to scan each row in column C and if it is not empty then capitalize the 1st letter. This syntax runs for about 12 seconds then I get an out of system resources error. Should I write this another way? What can I do to have this function execute as I need?

Please Login or Register  to view this content.

[cytop]

That code won't compile, never mind run long enough to exhaust resources... You use the same variable as the control in 2 For Loops.

Also, none of the defined constants for the END method has a value of 3.
xlUp = -4162
xlDown = -4121

As it is, the code is probably looping from 1 to 2 stepping -1 which means it will never even enter that For when you correct the duplicated loop variable.

[nilem]

Hi jo15765
try this

Please Login or Register  to view this content.

[jo15765]

@nilem - that got it. Thank you!