We have shown you how to get the Column number from Excel using the Column Function. But what if you need the actually letter for a macro in your VBA code? Here is how you do it. Here is the Code, don’t worry I’ll explain in a second: Sub Convert_Column_Letter() Dim MyColumn As String, [...]
How to Use Microsoft Excel Column Function
In Microsoft Excel, if you want to get the Column number you would use the Column Function. Here is the syntax for it: Column ( reference ) Reference is optional, if it isn’t specified, the Column Function will reference the cell it is in. Here are some example: If you entered in a Reference, like [...]
Awesome Water Fire iPhone Wallpaper
I saw these awesome iPhone wallpapers I almost cried, well I did a little, but click the images below to get them.
How to Lock Windows Desktop Without Hiding It
If you are like me you probably walk away from your computer and hit the WIN + L to lock your computer. This works perfect if you don’t want anybody to see what you have on your desktop. On the other hand, what if you do want someone to see your desktop. With ClearLock we [...]
How to Disable Caps, Num, and Scroll Lock Keys with NumLocker
The Caps lock, Num lock and scroll lock can be annoying at times, if you accidentally turn them on of course. Even when they are annoying there are times you just want them one. With NumLocker we can do either of these task. After you’ve downloaded and installed NumLocker, link below, it will be in [...]
How to Keep Windows Desktop from Crashing by Sandboxing Explorer Windows.
Windows Explorer process runs a lot of important Windows stuff. When Explorer crashes, it takes everything with it, well just your desktop and the taskbar. To stop this from happening we can enable a cool little trick that will sandbox each explorer instance in its own process. To enable this awesome feature go to an [...]
Daily Free App: Google Translate
In the past we reviewed another Translator app for our Daily Free App. This time we are going to go over another one by Google called Google Translate. Just like other translation apps you can select what language and translate the text. One of the cool features to Google Translate compared to the rest [...]
How To Find Out Who is Linking to your Site the Easy Way
A lot of SEO tools will tell you who is linking to your site. A really easy and simply way to do this is by going to Google or Yahoo and typing in “link:sitename” without quotes and replace sitename with the site you want to find out. Just like the picture below: Only one site [...]
Desktop Fun: Awesome Fedora Desktop Wallpaper
If you are a fan of Fedora like we are at Doztech please enjoy these awesome backgrounds:
How to Remove Spelling and Grammar Squiggle Lines from Word 2007
We all know that Microsoft Word 2007 will automatically check if a word is spelled right or has proper grammar. What if you intentionally spell something wrong, or it isn’t added to your custom dictionary, you have to look at those horrible red and green squiggle lines. The horror! Here is how to remove them. [...]
How to Make a Hanging Indent in a Word 2007 Paragraph
Word 2007 can hang the indentation of every paragraph you type. A hanging indent is an indentation where the first line sticks out to the left and the rest of the paragraph is indented. To do this we just need to enable a few simple steps. First go the the beginning of a paragraph you [...]
Windows 7
Windows Vista
Windows XP
Linux
Microsoft Office
Mobile
Web
Wallpaper
