ब्लॉगसेतु

सांगरी दर्पण
0
SESSIONCLASSSTUDENT NAME MARKSM.M.2004-0512th DESH RAJ30650010thSOURABH SHARMA5727002005-0612thMANJULA31550010thDHARMINDER KUMAR5767002006-0712thPREETI THAKUR33350010thCHANDRESH KUMAR5407002007-0812th DHARMENDER KUMAR37750010thLOVELY521700 2008-0912t...
 पोस्ट लेवल : HONOUR BOARD
समीर लाल
0
Dim appAccessDim nmsDim strFolderDim fldDim strAccessPathDim rstDim dbeDim wksDim dbsDim itmsDim itmSub CommandButton1_Click() Set nms = Application.GetNamespace("MAPI") strFolder = "fbtest folder" Set fld = nms.Folders("Personal Folders").Folders(strFol...
समीर लाल
0
Sub CommandButton1_Click()ExportToExcel()End SubSub ExportToExcel()Dim appExcelDim olMAPIDim strTemplatePathDim strSheetDim IfldDim MItemSet olMAPI = GetObject("", "Outlook.Application").GetNameSpace("MAPI")Set Ifld = olMAPI.Folders("Personal Folders").Folders("Sam...
समीर लाल
0
Suppose, your names seperated by "," is in cell A4.Here is the formula to calculate number of commas in the cell A4:=LEN(A4)-LEN(SUBSTITUTE(A4,",",""))The first part: LEN(A4) calculates length of string with commas. The Second part: LEN(SUBSTITUTE(A4,",","")) calcu...
समीर लाल
0
I find it very handy:Formatting numbers with named formats Expression Result Format(35988.3708, "general number") 35988.3708 Format(35988.3708, "currency") $35,988.37 Format(-35988.3708, "currency") ($35,988.37) Format(35988.3708, "fixed") 35988.37 Format(1, "fixed...
समीर लाल
0
When we are referencing one sheet data to another sheet in a formula or otherwise comparing multi sheets in a work book, it becomes tedious to move from sheet to sheet back and forth. Think of a situation where you have to refer data from three or four sheet.Wouldn...
समीर लाल
0
At times, when you have many workbook open on your desktop and wish to close all of them together,there is an easy way in MS Excel to do this. I could never understand the reason why this option is not on main menu and is kept hidden.Follow this:Press Shift key on...
समीर लाल
0
Click a cell of the row you want to sort horizontally.Select Sort from the Data menu.In the Sort dialog box, click on the Options.In the Sort Options dialog box, click on Sort Left to Right, then click OK.Back in the Sort dialog box, go to the Sort By combo box and...
समीर लाल
0
As a busy executive, you are presented with lots of data in MS Excel format. Though you know the formulas to calculate and find results, but it is just a waste of time to write formula to see what the sum of particular range is or which is the highest value or lowe...
सांगरी दर्पण
0
अगर आप इस साईट पर कोई ऐसी जानकारी पाते है जिस पर आपको आपत्ति है तो कृपया टिप्‍पणी के बाक्‍स में जानकारी दे कर कृतार्थ करें। ऐसी जानकारी / लेख को संशोधित कर दिया जाऐगा या हटा दिया जाऐगा। धन्‍यवाद।
 पोस्ट लेवल : REPORT ABUSE