Using VBA to find last non empty row: in column, in table 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. 05/08/23 Excel
Set the right MTU: meaning, calculator, settings 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. 01/06/23
How to resize partition Linux: Gparted, command line 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. 21/04/23
Script to automatically display webpage in fullscreen mode 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. 30/03/23 Mozilla Firefox
What is the equivalent of DATEDIFF in 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. 29/03/23 MySQL
What are the 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. 27/03/23
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. 27/03/23 Mac
How to increase your PC hard disk space? 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. 24/03/23 Windows 10
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. 23/03/23 MySQL
Execute a script in Windows: at 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. 22/03/23 Microsoft Windows 7 Ultimate Edition Windows 10 Windows 11