VBA to sort columns

Office

Question:I have a name column and a column next to that with time, example (0 h: 51 m: 31 s). There may be up to 10 columns, the names of 10 with 10 times.Ranges are:Column name C4: C13Time column D4: D13I would like a code to sort them to lower both the times higher in the following ranges:Column name C21: C30Time column D21: D30Thank youAnswer:HelloTry thisSub sort_Time()Dim C As RangeRange ("C4...Read More

Posted: 18 Apr 2012

Tags: VBA to sort columns VBA sort columns

Why my Excel for Mac 2011 let complete me the columns after the column IV but where to save the file and reopen it nothing past shows column IV?

Mac

Asked why I continue to lose columns beyond IV. I was told by microsoft telephone support staff member who, apparently, in this version of excel it's a natural limitation? But this makes no sense?.Probably becayse you save the file in xls format. In this mode, only 256 columns are available. Save the file as xlsx and you can fill to column XFD.Read More

Posted: 18 Apr 2012

Tags: Why my Excel for Mac 2011 let complete me the columns after the column IV but where to save the file and reopen it nothing past shows column IV Why Excel for Mac 2011 let complete the columns after column but where save file and reopen nothing past shows

Automatic Columns

Office

Question:How can I Word 2007 to automatically open with a column? Now, when I create a new document, I have to go to layout and change to 1 column each time. When I send the documents by e-mail, recipients cannot see anything other than the first page until they adapt their columns as well.Answer:Edit the document to a column, and then go to Page Layout tab and open the window settings of the Page...Read More

Posted: 29 Mar 2012

Tags: Automatic Columns Automatic Columns

Can you change the widths of column on multiple pages without affecting the width of the columns in the previous pages?

Office

Question:I'm trying to find out if you can change the width of columns on 1 page without affecting the width of columns in a different page. For example, I have 3 pages with default column widths, and now I am trying to copy a page excel from a different file that has the width of the different columns. I can not file copied to adapt without changing the widths of column for all pages.Answer:If by...Read More

Posted: 10 Mar 2012

Tags: Can you change the widths of column on multiple pages without affecting the width of the columns in the previous pages Can you change the widths column multiple pages without affecting width columns previous

move columns to MS Office 2010, cannot move the status flag on the left

Office

Question:I want to change the status of the indicator of the far right in MS Office 2010, but were unable to do so. I choose view, click with the right button on the bar (?) topic and select "Display settings" and select "show columns." Move the State of the indicator at the top of the list (order of columns) and answer OK twice, but nothing happens. The "State flag" is on the far right. The reason...Read More

Posted: 05 Mar 2012

Tags: move columns to MS Office 2010 cannot move the status flag on the left move columns Office 2010 cannot the status flag left