Stuck on VBA code

[Lou_Reed]

In the attached spreadsheet when I press the form control button to select cells everything is fine. The


cells with something in them are selected.

Then when I press the form control button to Change Selected Cells to Text - well weird things happen.

It seems that a lot more cells are now selected and then it starts with the circled (going round and round) in
an attempt to change selected cells to text. Where is the hourglass?

It appears to be stuck. The number of selected cells are much larger now since I press form control button to
change selected cells to text. It is understand able that it may be stuck too many cells are now selected.

What is the problem here?

Ay help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[June7]

Why are you selecting the ENTIRE spreadsheet in changenumbertotext()? Suggest you remove that line.

Code in texttonumbers() should not prefix with a space. Use: c = c.Value

I made corrections, select cells with the button, run the change procedures. Code is not stuck, just takes a long time. The more cells selected, the longer it takes.