Tag Archives: Excel

Multiple Excel Text Boxes With Common Content

Posted on June 29, 2012 by Ross (Admin)

I have just had to place a textbox object onto 17 worksheets within the same excel workbook, each text box containing the same commentary text. Type it once and then copy the text box and paste, job done. Of course … Continue reading →

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Microsoft Office–VBA Editor Keeps Opening

Posted on October 7, 2011 by Ross (Admin)

For weeks now I have had the mild annoyance that the VBA code editor for various Excel spreadsheet’s appear to be opening at “random”. I finally tracked it down to me unlocking my PC. If I have excel running then … Continue reading →

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Changing Excel Cell Values To Uppercase

Posted on August 23, 2011 by Ross (Admin)

A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase. Create a macro: sub MakeUpper() for each myCell in Selection   myCell.Value = UCase(myCell.value) next myCell end sub Add a … Continue reading →

Posted in Microsoft, Office | Tagged , , , , | Leave a comment

MS Excel – Convert Percentage To Number

Posted on July 25, 2008 by Ross (Admin)

I have spent most of today throwing data around in MS Excel. One of the things that I have had to do is to convert percentages into real numbers. In excel percentages are stored as fractions, for example 50% is … Continue reading →

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Office, Work | Tagged , , , , , | 5 Comments

Latest ETL Tool – MS Excel

Posted on July 25, 2008 by Ross (Admin)

I have spent all day in MS Excel. I receive excel spreadsheets in a “fairly” fixed format. I need to get this data into Business Objects Xcelsius via another spreadsheet that stores historical records and keeps the data in a … Continue reading →

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Work | Tagged , , , , , , | 2 Comments

Microsoft Excel 2007 Annoyances

Posted on May 20, 2008 by Ross (Admin)

I have had office 2007 on my laptop for ages now. Like everyone I am still using the “old” file formats until the rest of the world catches up. On the whole I have been impressed by the ribbon interface. … Continue reading →

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Work | Tagged , , , , , , | Leave a comment