Best Blogging Tips and Templates,Windows Hacks: “Swap Cell Values in Excel Using Macro” plus 1 more

Link to Blogger Tips and Hacks | Best Blogger Templates | SEO Tips and Tricks

Posted: 20 Jul 2010 07:12 AM PDT

Today i was working with excel and found that i have entered some values in excel sheet at wrong place. Now i want to swap cell values in my excel 2007 sheet. i have first tried to find it in google but nothing seems to be worked for me, then i have prepared the below highlight macro which can swap two selected cells in any excel sheet.

Sub Swap()
Dim cval(), cadd()
a = 1
ReDim cval(2), cadd(2)
For Each usrcell In Selection
cval(a) = usrcell.Value
cadd(a) = usrcell.Address
a = a + 1
Next usrcell
Range(cadd(1)).Select
ActiveCell = cval(2)
Range(cadd(2)).Select
ActiveCell = cval(1)
End Sub

To add above VBA code in your excel sheet as a macro press Alt+F11 and paste above code. Save and Exit from that window.

Now to swap values of two cells you need to just select those two cells and run the macro (Alt+F8).

Hope you all will like this macro. Try it and let me know. :)

Microsoft Office 2010 e-book Download (Operation Guide for Office 2010)

Posted: 19 Jul 2010 08:05 PM PDT

Microsoft Office 2010 e-book Download: Microsoft has just released an interesting ebook for its new product, Microsoft office 2010. The digital ebook comes in different formats namely: docx, pdf and xps. According to Microsoft "Operation Guide for Office 2010″…provides information about how to maintain and manage an installation of Microsoft Office 2010." Here is what you will be able to find in this free, Office 2010 ebook.

Microsoft Office 2010 Beta Edition Free Download

How to manage, update and configure your Office 2010 after the first installation.
Complete list of all available updates for Office 2010.
Office 2010 Administrative template files as well as all those tools to customize the whole package.
How to uninstall office 2010 and install a previous, old Office package.
Adding or removing languages after deploying Office 2010.
How to manage and change user configurations.

Download the book in PDF format: ORKOperations.pdf

Download the book in DOC format: ORKOperations.doc

Download the book in XPS format: ORKOperations.xps

Sense of Adsense