All about Web and Desktop Application
This is VB code which will auto sort all sheets in the active workbook after execute it. It is easy for us to locate sheets when we have many sheets in our workbook.
Open the workbook for which we want to sort the sheets and press Alt + F11 to open the Visual Basic Editor, and select Insert > Module to insert a module. Copy and paste the following code in module just created.
Popularity: 8% [?]
A nice script from Benjamin Keen – Black Sheep Invoices. With it, you can manage all your invoices directly on your web browser.
You can try it through its live demo here before install in your server. Don’t worry about its pricing, it is absolutely free!
Popularity: 8% [?]
Here is a amazing and beautiful script from Dan Vanderkam. We can just drag the column headings to rearrange the data in the table.
Here is its URL for dragtable: http://www.danvk.org/wp/dragtable/
Popularity: 8% [?]
Yes, a new web browser from Goolge – Google Chrome. As per what Goolge mention in its official website, it is a browser that combines a minimal design with sophisticated technology to make the web faster, safer, and easier.
Google Chrome
Popularity: 8% [?]
You may sometimes forgot your password of your Microsoft Excel sheet or workbook, or the original author (usually ex-colleague) lock the workbook and didn’t unlock it for next user, the marco below will unlock your sheet or workbook not matter what your original password is. However, it will NOT report the original password.
1. First open your protected excel file
2. Launch the Visual Basic Editor
3. Copy and paste the following VB Code
Popularity: 100% [?]
Upload .psd designs, download .html file and images. It’s that simple to create CSS compliant webpages.
Some web designers may not have fully knowledge to master CSS, and many of us are good enough with little bit of brushing and designing in PhotoShop. Now, I found a great website, PSD to CSS Online, which provide free service to convert PhotoShop creations into CSS pages online.
Popularity: 35% [?]
If you want to install and set up a dynamic web server with Apache, a lot of applications such as Apache web server, mySQL database, PHP and Perl scripting language, and not to mention important extensions and tools to manage the web server’s applications. It’s not a easy and simple task. But luckily, there is XAMPP from Apache Friends.
XAMPP is a collection of free software applications for installing and using the Apache Web server. There are different combination of applications depending on which XAMPP distributions. Currently there are four type of XAMPP distributions available: XAMPP for Linux (previously known as LAMPP), XAMPP for Windows, XAMPP for Mac OS X, XAMPP for Solaris. Typically, XAMPP is a full featured AMPP (Apache MySQL, PHP, Perl), an Apache distribution that includes the Apache Web server, MySQL database, PHP, Perl, FTP server and phpMyAdmin, with several other important and commonly used extension built-in, such as SSL.
Popularity: 26% [?]
Live HTTP headers – tinyurl.com/yvmhkf
This extension shows you the raw HTTP headers that a webserver returns. It’s very handy for debugging issues with 404s, redirect, monitoring cookies and so on.
Greasemonkey – tinyurl.com/ynvmda
Greasemonkey is a useful tool that lets you write scripts to modify different websites. It enables you to change the way a website displays and install different scripts to customise HTML pages.
RefreshBlocker – tinyurl.com/2wz2k2
This extension will prevent your browser from following the forwarding specified by the refresh parameter of the META tag element. It can also be handy for debugging.
ShowIP – tinyurl.com/3xj8r5
Show you the IP address of a website and allow you to copy it to the clipboard. It also allows querying custom services by IP (right mouse button) and Hostname (left mouse button), like whois, netcraft. Additionally you can copy the IP address to the clipboard.
Popularity: 10% [?]
You don’t like to scroll? Be prepared. (We warned you.)
Every now and again designers stumble upon the very same problem: the choice of a unique and beautiful typeface which manages to fulfill three basic tasks. Support the corporate identity, enrich the visual appearance and is compatible with the overall design. However, usually there are simply too many options you can consider, which is why you need time to find the option you are most comfortable with. Although the choice usually depends on clients’ requirements, it is necessary to have some pretty starting points for your font decision.
So which typefaces are “bulletproof”? What fonts can be used effectively in almost every Corporate Design? And what are the options for unique, but still incredibly beautiful typefaces?
We have answers. Over the last few days we’ve browsed through dozens of type foundries, read dozens of designers’ articles about typography, analyzed font rankings and visited bookmarked font-related suggestions. So this post has ‘em all. Well, OK, at least many of them.
Let’s take a look at over 80 gorgeous typefaces for professional design, based upon suggestions from designers and web-developers all over the world. Most screenshots are taken from the foundries and provided specimens – particularly on Veer.com and Fontshop.com.
Popularity: 54% [?]
Sum a range that contains error values
The SUM function in Microsoft Excel doesn’t work when you try to sum a range that contains an error value such as #N/A. This example shows you how to sum the values in a range named “Data” that contains errors:
=SUM(IF(ISERROR(Data),"",Data))
The formula creates a new array that contains the original values minus any error values. Starting from the inner functions and working outward, the ISERROR function searches the cell range (Data) for errors. The IF function returns one value if a condition you specify evaluates to TRUE, and another value if it evaluates to FALSE. In this case, it returns empty strings (“”) for all error values because they evaluate to TRUE, and the remaining values from the range (Data again) because they evaluate to FALSE, meaning that they don’t contain error values. The SUM function then calculates the total for the filtered array.
Popularity: 17% [?]
This article was written by Ashish Mathur, a Microsoft MVP (Most Valuable Professional). Visit the Microsoft MVP Web site for more information.
In the following article I explain a formula that extracts numbers from strings in the following types of situations:
abc123 or 678sfr.abc15tni.Problem
How to extract the numeric portion of an alphanumeric string. For example: If cell A1 contains the string “abc123″, return the value 123 in cell B1.
Solution
The underlying logic here is to search for and return the first number in the alphanumeric string, and then return only the numbers that follow.
Popularity: 24% [?]
This article was adapted from MrExcel.com. Visit the MrExcel.com Web site for more tips and information.
Conditional formatting in Excel allows for three conditions. However, by setting up conditions correctly — from least to most restrictive — you can really allow for four conditions, when the default formatting of the cell is considered. For example, say you want to add color to your data like so:
| If cell value is | Fill with |
|---|---|
| Less than or equal to -25 | Red |
| Between 0 and -25 | Yellow |
| Between 0 and 25 | Green |
| Over 25 | Black |
Popularity: 9% [?]
Subscribe in a reader
Or, subscribe via email: