Now when you return to your spreadsheet, you should see the text centered across the cells that you selected. Click on 'Center Across Selection' in the drop-down box called Horizontal. I do not really want to manually edit this file to change this format to something else. When the Format Cells window appears, select the Alignment tab. How do I get my macro to find out that even if the cell value is null, the "real" value is "Year To Date" ? The only cell that has a value in U20:AA20 is the U20 which has the "Year To Date" value. It works fine for a table without any special format but I have troubles with the "center across selection" format because the cell X20 is empty. I use these criteria to test this set of lines (line 20 to 22) for each column. What I want to do is for example to get my macro to find the column X which is the first column to match my 3 criteria (in this case Year To date, Budget and Feb/07). I have this table and I am having troubles in retrieving values from a centered across selection row.Ĭells are not merged, it is just a simple center acrosse selection that has been used.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |