Change Case Horror

[epicode]

I recently used change case feature and to my horror it
1. did not warn
2. changed case for whole sheet instead of selection
3. no way to undo
4. no backup of sheet

I hope you rectify Change Case Tool issue to prevent Data Loss!

[SteveT]

Sorry to hear that. I have been unable to replicate this. Are you able to reproduce the issue?

[epicode]

Yes I can reproduce the issue in a specific file.

[SteveT]

Care to share how to reproduce it?

[epicode]

I can share a dummy excel file which reproduces this behavior. let me know email id.

[SteveT]

You can add attachments to a message here.

[epicode]

Select only one cell and change case to anything - it will affect all the other cells
works normally if two or more cells are selected.

[SteveT]

Thanks. The issue occurs when a single cell is selected and some part of the worksheet is hidden (like columns are hidden). In this case, the function SpecialCells returns all cells instead of the correct range. This appears to be a bug/feature of Excel, depending on how you interpret the implementation. In any case, I consider it a bug, so I am adding some additional code to detect and workaround it.

Meantime, understand the workaround is to select more than one cell if any area is hidden.

Thanks, Steve