![]() ![]() ![]() Obviously, I am aware of the existence macros but don't know how to write them properly. Any help one could give would be greatly appreciated. Number format (only for cells than contain letters) = Text The real problem is resetting the vertical alignment. In a perfect world, it would be wonderful also for the horizontal alignment to be set to left, the text wrap to be turned off, and the number format to be set to text for any cells that don't contain numbers (or at least those that are already not set to "Number")-all without affecting anything else in the cell, like the indents-but these would just be gravy. Alternatively, one can do it cell by cell, which also does not affect the indents. Is it possible to have simple Excel macro to change the cell vertical alignment to center throughout a table without affecting the indents? When doing it manually, one has to first select cells with similar indents to change the alignment-otherwise, the indents are changed to match those of the first selected cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |