/account/irene-burn-11854879enThu, 30 Apr 2026 15:55:54 +0200Thu, 30 Apr 2026 15:55:54 +0200https://ccm.net/apps-sites/software/4027-vba-last-non-empty-row-all-versions/Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook from one version to another.]]>Sat, 05 Aug 2023 08:49:00 +0200https://ccm.net/apps-sites/software/4027-vba-last-non-empty-row-all-versions/https://ccm.net/computing/networks/2283-how-to-set-the-right-mtu/In Digital Networks, MTU(Maximum Transfer Unit) is the parameter that decides the largest datagram transferred without being fragmented through the network. Below is an introduction to MTU as well as an explanation on how to calculate it. Also, find out its value in Windows and Linux and how to change them.]]>Thu, 01 Jun 2023 12:34:00 +0200https://ccm.net/computing/networks/2283-how-to-set-the-right-mtu/https://ccm.net/computing/linux/3067-how-to-resize-a-partition-using-gparted-on-linux/Operating systems, such as Linux, provides partitioning software to resize partitions without any data loss. It's possible to resize a partition using Gparted in an easy and a convenient way. Gparted partitioning software is available for free download. To modify the partition with Gparted, it has to be downloaded and then burned into a blank CD.]]>Fri, 21 Apr 2023 13:40:00 +0200https://ccm.net/computing/linux/3067-how-to-resize-a-partition-using-gparted-on-linux/https://ccm.net/apps-sites/web/1935-script-to-automatically-display-webpage-in-fullscreen/The Full Screen option is available on most web browsers by clicking on the relevant link. However, IE and Firefox can support a software code in windows API that is heavy in flux and enables the automatic full screen display of a webpage. JavaScript can work in IE and combines the small order even if the window is closed in the Firefox web browser. It works for versions 2.0 or older.]]>Thu, 30 Mar 2023 15:23:00 +0200https://ccm.net/apps-sites/web/1935-script-to-automatically-display-webpage-in-fullscreen/https://ccm.net/computing/programming/3003-equivalent-of-datediff-function-of-the-sql-server-under-oracle/DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function.]]>Wed, 29 Mar 2023 11:15:00 +0200https://ccm.net/computing/programming/3003-equivalent-of-datediff-function-of-the-sql-server-under-oracle/https://ccm.net/computing/hardware/9759-sound-card-connections-and-color-codes/A sound card (also called an audio card) is the part of a computer that manages its audio input and output. Nowadays, computers usually have it integrated into their motherboard. In this article, we will introduce this critical component.]]>Mon, 27 Mar 2023 16:30:00 +0200https://ccm.net/computing/hardware/9759-sound-card-connections-and-color-codes/https://ccm.net/computing/networks/9937-what-is-a-network-card/A network card (also called a network adapter, network interface card, or NIC for short) acts as the interface between a computer and a network cable. The purpose of the network card is to prepare, send, and control data on the network. In this article, we will introduce this component.]]>Mon, 27 Mar 2023 11:42:00 +0200https://ccm.net/computing/networks/9937-what-is-a-network-card/https://ccm.net/computing/windows/1787-how-to-increase-the-cache-on-your-hard-disk/Have you found that you are running low on hard disk space? In this article we will show you how to increase the cache of your hard disk and improve the performance of your PC.]]>Fri, 24 Mar 2023 11:21:00 +0100https://ccm.net/computing/windows/1787-how-to-increase-the-cache-on-your-hard-disk/https://ccm.net/computing/programming/2045-phpmyadmin-access-denied-for-user-root-localhost/In PHP programming language there is an open source tool called PhpMyAdmin that handles the administration of MySQL. Access can be denied when access to MySQL is attempted through the root user. Root requires insertion of a password and once that is wrongly entered or is not provided, this issue arises. This can be configured with the help of the PHP tool. The rights of the root user can also be reset at the same time.]]>Thu, 23 Mar 2023 15:48:00 +0100https://ccm.net/computing/programming/2045-phpmyadmin-access-denied-for-user-root-localhost/https://ccm.net/computing/windows/2581-execute-a-script-a-startup-and-shutdown/To perform certain customized functions, scripts can be run when Windows Operating System starts or shuts down. The method to execute a script at startup or shutdown varies with different versions. Here's how to execute scripts at shutdown and startup.]]>Wed, 22 Mar 2023 15:53:00 +0100https://ccm.net/computing/windows/2581-execute-a-script-a-startup-and-shutdown/https://ccm.net/apps-sites/software/1621-excel-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.]]>Mon, 20 Mar 2023 15:42:00 +0100https://ccm.net/apps-sites/software/1621-excel-run-macro-when-data-entered-in-a-cell/https://ccm.net/computing/hardware/2683-cups-pdf-for-windows/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.]]>Mon, 06 Feb 2023 16:47:00 +0100https://ccm.net/computing/hardware/2683-cups-pdf-for-windows/https://ccm.net/apps-sites/software/1593-excel-using-if-statement-to-add-1-to-total/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.]]>Thu, 15 Dec 2022 15:07:00 +0100https://ccm.net/apps-sites/software/1593-excel-using-if-statement-to-add-1-to-total/https://ccm.net/apps-sites/software/1601-excel-formula-based-on-the-color-of-cell/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.]]>Mon, 12 Dec 2022 14:11:00 +0100https://ccm.net/apps-sites/software/1601-excel-formula-based-on-the-color-of-cell/https://ccm.net/computing/windows/2795-windows-incremental-backup-of-data-with-bat-batch/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.]]>Wed, 23 Nov 2022 12:23:00 +0100https://ccm.net/computing/windows/2795-windows-incremental-backup-of-data-with-bat-batch/https://ccm.net/apps-sites/software/3027-concatenate-vectors-or-matrices-under-matlab/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.]]>Fri, 18 Nov 2022 12:01:00 +0100https://ccm.net/apps-sites/software/3027-concatenate-vectors-or-matrices-under-matlab/https://ccm.net/apps-sites/software/3227-how-to-open-read-a-dvi-file-format-on-windows/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.]]>Thu, 10 Nov 2022 13:23:00 +0100https://ccm.net/apps-sites/software/3227-how-to-open-read-a-dvi-file-format-on-windows/https://ccm.net/apps-sites/software/3231-how-to-manipulate-data-in-excel-using-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.]]>Tue, 08 Nov 2022 18:35:00 +0100https://ccm.net/apps-sites/software/3231-how-to-manipulate-data-in-excel-using-vba/https://ccm.net/apps-sites/software/3279-excel-exporting-data-to-another-spreadsheet/Exporting data from one Excel spreadsheet to another spreadsheet is always a problem if you want to have the same content in the second too. We sill see how to solve this problem with an example.]]>Tue, 08 Nov 2022 10:55:00 +0100https://ccm.net/apps-sites/software/3279-excel-exporting-data-to-another-spreadsheet/https://ccm.net/computing/hardware/3347-front-panel-audio-connectors/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.]]>Thu, 03 Nov 2022 11:17:00 +0100https://ccm.net/computing/hardware/3347-front-panel-audio-connectors/