The latest articles by Irene Burn

  • How to run macro when data entered in a cell

    If a user wishes to run a Macro in Microsoft Excel 2007 when the D10 cell is found to be populated, worksheet change event must be used in the Excel Worksheet, not in the module. This article will show you how to run a macro when cell value changes.

  • Cups-pdf for Windows: driver, virtual PDF printer

    Cups-pdf is an add-on for the CUPS (Common Unix Printing System) printing system of Unix. This feature allows you to easily convert printable files into PDF files. The Cups-pdf can be accessed from any application that contains the document and allows printing of the document.

  • How to use an IF statement, excel, with text, vba

    The IF function in Excel is a powerful tool that allows you to perform logical tests and return different values based on the results of those tests. It's commonly used to make decisions and perform calculations in spreadsheets.

  • How to use Excel color cell if formula

    Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts such as if-else conditions and looping may be useful to write user defined functions. To write a function to determine the color of a cell, the interior color object can be used.

  • How to backup Windows data: with .bat

    Data Loss is a big issue associated with formatting your computer. It is good to know that Windows comes with backup and recovery solutions that can prevent this problem. We can use the incremental backup to save important data in the computer before formatting. The Backup Utility of Windows systems supports this type of backup and saves all files that have changed since the last one and prevents data loss. Here's how to make a backup on Windows.

  • Matlab concatenate vectors: vertically, horizontally

    The operation of concatenating vectors or matrices under MATLAB is defined as a combination of the variables in a single vector or matrix. There are two types of concatenation operation: horizontal and vertical. For horizontal concatenation, two variables should have the same number of rows. In case of vertical concatenation, two variables should have the same number of columns. Every available variable cannot be concatenated.

  • How to open DVI file: Windows, online

    DVI is the acronym for the Device Independent file format, which is the output file format for documents written in LaTeX. These files are essentially binary files. LaTeX file.Tex creates this file. To see the .DVI file on the Windows platform, download and installation of MiKTex is a must. Once the procedure of the installation is complete, double clicking the DVI file and it will open it.

  • How to manipulate data in Excel: VBA

    Microsoft Excel is a powerful tool that can be used for data manipulation. To make the most of the software, you need to use VBA. Visual Basic for Applications, or VBA, allows Excel users to create macros, which are powerful time-saving custom functions for data manipulation and analysis. Macros process VBA code to manage large data sets that would otherwise take a lot of time to modify.

  • Front panel audio connector: function, diagram, not working

    System users do not always know where all the critical points of cables are. Sometimes difficulties are encountered in connecting jacks to the motherboard. Generally the difficulty is located in the front panel and the audio connection is then disturbed. Due to the difference in the connection box and motherboard, cables get distracted.