Clear Contents without Clearing Formula

Sub ClearItOut()
Cells.Select
Selection.SpecialCells(xlCellTypeConstants, 1).Select
Selection.ClearContents
End Sub

Merge Sheets in 1 Sheet in Excel

Sub Merge()
Dim ws As Worksheet
ActiveSheet.UsedRange.Offset(0).Clear
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> ActiveSheet.Name Then
ws.UsedRange.Copy
Range("A65536").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End If
Next
End Sub

Highlight Duplicate Entry

Sub FindDups ()
   '
   ' NOTE: You must select the first cell in the column and
   ' make sure that the column is sorted before running this macro
   '
   ScreenUpdating = False
   FirstItem = ActiveCell.Value
   SecondItem = ActiveCell.Offset(1, 0).Value
   Offsetcount = 1
   Do While ActiveCell <> ""
      If FirstItem = SecondItem Then
        ActiveCell.Offset(Offsetcount,0).Interior.Color = RGB(255,0,0)
        Offsetcount = Offsetcount + 1
        SecondItem = ActiveCell.Offset(Offsetcount, 0).Value
      Else
        ActiveCell.Offset(Offsetcount, 0).Select
        FirstItem = ActiveCell.Value
        SecondItem = ActiveCell.Offset(1,0).Value
        Offsetcount = 1
      End If
   Loop
   ScreenUpdating = True
End Sub

Delete Spaces in the Cell

Sub TrimBText()
' This module will trim extra spaces from BOTH SIDES.
    Dim MyCell As Range
    On Error Resume Next
        For Each MyCell In Selection.Cells
            MyCell.Value = Trim(MyCell.Value)
        Next
    On Error GoTo 0
End Sub

Delete rows if A1 is Blank

Delete rows if A1 is Blank

Sub DeleteRowsThatLookEmptyinColA()
  Application.ScreenUpdating = False
  Application.Calculation = xlCalculationManual   'pre XL97 xlManual
  Dim Rng As Range, ix As Long
  Set Rng = Intersect(Range("A:A"), ActiveSheet.UsedRange)
  For ix = Rng.Count To 1 Step -1
      If Trim(Replace(Rng.Item(ix).Text, Chr(160), Chr(32))) = "" Then
        Rng.Item(ix).EntireRow.Delete
      End If
  Next
done:
  Application.Calculation = xlCalculationAutomatic
  Application.ScreenUpdating = True
End Sub

Juliyanaa.. Juliyaana..

    Kaalzaan thaavun mog thuzo haanv karthaam
    Sadaanch tujea mogaak ashethaam
    Dees raath swapnaanth thukaa dekhthaam
    Fudaar chinthun dukham galaithaam ||2||

    Thum mogaa hene thene vaat chamkathaana
    Gumaan deenanyi maaka parvaa thukaa naa
    Haanv thukaa mujench korunk mothinth chinththaanaa
    Kithyaak saandun gelaanyi maaka somzaana

    Juliyanaa.. Juliyaana.. Mogaa mujea.. Juliyaanaa..

    Eksurponan saandlaanyi mu go maaka
    Thuje vine saunsaar naaka
    Borem maagun aadevch karthaam mogaa
    Kaaliz sadaanch chinththelem thukaa ||2||

    Thum mogaa hene thene ... maaka somzaana

    Juliyanaa.. Juliyaana.. Mogaa mujea.. Juliyaanaa..

Illo Illo Soro Piyelo Konkani song

    Illo Illo Soro - Henry D'souza
    Illo illo illo illo soro piyelom
    illo illo munon maaka chod chod zaalo
    Chod chod zaathana mujea thoklek chodlo
    Kithle paavtin soro piyevn ghataraanth podlon ||2||

    Ek dees soro piyevn ghara yethalom
    Shidiyo chodun ghar mun chinthun daar bodoithalom
    Chedvanchem them hostel munon nenaa aslolom
    Chor chor munon maaka polisaank dilo ||2||
    Polisani maaka maarlo anim jailaanth lotlo
    Amaal firvaathana muzo maanddo thaasllo ||2||

    Illo illo ..ghataraanth podlon

    Baaraa voraar raathik haanv ghara paavullom
    Daaraar mujea Raagaar haanv khoto ghaalthalom
    Daar ugaadthana re ek daadlo aslolo
    Daadlyak polevn raag mujea thoklek chodlolo ||2||
    Daadlyaak haanvem maarlo thaacho maanddo futailo
    Polenvk gelyaar muzoch tho maanv aasllo ||2||

    Illo illo ..ghataraanth podlon

    Ek dees tight zaavun ghara yethalom
    lokun lokun vaat chukon maargaar podlom
    Baail mujhi kiss dithaa munon swapnelom
    Polenvk gelyaar thond mujhem peto lenvthaalo ||2||
    Kushin bhava vodlo ek redo raavullo
    Bhathen munon chinthun mujhi lungi chaabthaalo ||2||

    Illo illo ..ghataraanth podlon ||2||
    Kithle paavtin soro piyevn ghataraanth podlon
    Kithle paavtin soro piyevn ghataraanth podlon.....

Divine mercy chaplet (Daivik Kakulthiso Ters konkanni)

ದೈವಿಕ್ ಕಾಕುಳ್ತಿಚೊ ತೇರ್ಸ್

1. ಆಮ್ಚಾ ಬಾಪಾ

2. ಏಕ್ ನಮಾನ್ ಮರಿಯೆ

3. ಸತ್ಮಾಂತ ದೆವಾಕ್ (ಸಗ್ಳೆಂ ಏಕ್ ಪಾವ್ಟಿಂ ಮ್ಹಣ್ಚೆಂ)

ಸಾಸ್ಣಾಂಚ ಬಾಪಾ ಹಾಂವ್ ತುಕಾ ಭೆಟಯ್ತಾಂ ಆತಿ ಮೊಗಾಚ್ಯಾ ಪುತಾಚಿ, ಆಮ್ಚ್ಯಾ ಸೊಮಿಯಾ ಆನಿ ಸೊಡ್ವೊಣ್ದಾರ ಜೆಜು ಕ್ರೀಸ್ತಾಚಿ ಕೂಡ್ ಆನಿ ರಗತ್, ಆತ್ಮೊ ಆನಿ ದೇವ್ ಪಣ್ ಆಮ್ಚ್ಯಾ ಪಾತ್ಕಾಂಚ ಆನಿ ಸಗ್ಳ್ಯಾ ಸಂಸರಾಚಾ ಪಾತ್ಕಾಂಚಾ ಪಾರಿಕ್ಪಣಾಂ ಪಾಸತ್ (ವೊಡ್ಲ್ಯಾ ಮಣಿಯಾಂಚೆರ್)

ಜೆಜುಚಾ ಕಠಿಣ್ ಕಷ್ಟಾಂಚ ಪಾಶಾವಾಂ ಮಾರಿಫಾತ್ ಆಮ್ಚ್ಯಾ ಆನಿ ಸಗ್ಳ್ಯಾ ಸಂಸಾರಾಚಿ ಕಾಕುಳ್ತ್ ಕರ್ (ದಾಕ್ಟ್ಯಾ ಮಣಿಯಾಂಚೆರ್)

ಏ ಭಾಗೆವಂತ್ ದೆವಾ, ಏ ಭಾಗೆವಂತ್ ಬಳ್ವಂತಾ, ಏ ಭಾಗೆವಂತ್ ಆಮಾರ ಆಮ್ಚಿ ಆನಿ ಸಗ್ಳ್ಯಾ ಸಂಸಾರಚಿ ಕಾಕುಳ್ತ್ ಕರ್.(ಅಖೇರಿಕ್ ತೀನ್ ಪಾವ್ಟಿಂ)

ತಸ್ವೀರ್ ಪಳೆಯಾ

Yarigelona namma problemu (Lifu Ishtene) lyrics

yarig helona namma problemu
hudugara novige illa mulaamu
hale girl friendsigella kotta salamu
kiviyalli nivu itta hoovey kayammu
yelle idrunu neevu henge idrunu
bathroomnalladru hadri namma poemu
maji hugideera lifey thumba aramu

yarig helona namma problemu
hudugara novige illa mulaamu

thumba sanna huduga antha andkondidhe nanu yelne classalli
gejje sound madikondu kunto bille adtha bandhlu hesaru vaishali
yako yeno namma devru bathi idok kalthbittavney
hugugi yedru mathaddage nalge mele kunthkondavne
naanu vaishaalige i love you antha helakagilla
aake nanagitha ondu footu yettra beledubitlalla
yaarigelona namma hightu problemu
vaishaalini nee yake kudide complanu

sheela siklu pucilli  kara kammi hakisikondu pani puri thindvi
kainetikinalli ibru obre kuntha hage kunthu odadkondu idvi
saki tanknallavala jothe ijadida kanasu bithu
midnightalli mysore roadu namibranna nodtha ithu
lovu nethige yeri nanu marthe colleju metlu
aadre ondu divsa sheela seeda bandu raki katbitluuuuu
yarigelona ellargu samu problemu
henmaklige anna aagi bitkonde rammu


degree maduvaga omme bassu passigantha nanu Qnalli hode
nanna hinde ninthovlige thuti pakka machhe ithu hesaru helalare
arda second saku nange bilodakke lovinalli
amele yeno aithu antha nimge nanu henge heli
avalige nanu nooraondne boyfriend agidde kanri
century hoddovla munde nanu bacha aagode kanri
yarigelona namma nextu problemu
nanna flash backey ondu chewingu gammu

Highlight Duplicate Entry in Excel

You may have to highlight duplicate entries in the excel and you may think it is very difficult to do. We have a solution for it. You need to just copy the below code and it to the excel.

In order to add the code to excel, please follow the steps given below:
1. Open the Excel file.
2. Right click on the page name.
3. Click on the 'View code' option.
4. Paste the following code and save.

Sub FindDups ()
'
' NOTE: You must select the first cell in the column and
' make sure that the column is sorted before running this macro
'
ScreenUpdating = False
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1, 0).Value
Offsetcount = 1
Do While ActiveCell <> ""
If FirstItem = SecondItem Then
ActiveCell.Offset(Offsetcount,0).Interior.Color = RGB(255,0,0)
Offsetcount = Offsetcount + 1
SecondItem = ActiveCell.Offset(Offsetcount, 0).Value
Else
ActiveCell.Offset(Offsetcount, 0).Select
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1,0).Value
Offsetcount = 1
End If
Loop
ScreenUpdating = True
End Sub.

5. Sort the column using 'Sort' option. 

6. Go to the macros and click on the 'Run' button.
7. Duplicate entry will be shown in red.

Investments in Share Market

Indian Share Market is crashing. However, you can make money by investing on the following shares. Even the SENSEX has fallen down, you can view the upward movement in this share. Those who are small investors can invest and get a huge profit.
1.

506457

GUJ.CARBON

2.

530519

INTERFACE

MySQLDumper - An Easy way to take backup of MYSQL Database

MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and - if needed - restore it. It is especially suited for shared hosting, where you don't have shell access. This application can be easily installed to your account.

In order to install this application, you need to download the application by Clicking Here. Once you have downloaded the file, please upload to your account and unzip the file to a folder. Access the folder and it will ask the database name, username, password and hostname. You need to enter the database details of the database of which you need to take the database backup. Once it is done, you can easily take backup of the database and store in your account as well as download it to your computer.