Search results

Here is some vba code that I have written that creates an "Index Sheet" at the beginning of the workbook. You could update the code to delete the Index Sheet before it runs each time that way you don't have to manually do it? Option Explicit Public Sub SheetNames() 'Macro created for...

Hui -- is there a way to program that custom format backwards? For example if the cell already has 12.3k in it, it can read 12,300 when it is done? Thank you in advance.

Awesome tip -- hadn't even thought of that. Thanks for the quick reply! Long time stalker on this forum, but I've been able to answer most of my problems myself or by reading other posts. Thanks again.

Quick question relating to VBA. I have a sheet of financial statement data where cells contain text, such as 1.46M, or 14.0K, etc. I would prefer that each individual cell contained the actual value, so the 1.46M cell should show 1,460,000 and the 14K cell should show 14,000. I came up with...