Wednesday, July 7, 2010

Highlight Active Cell in MS Excel 2007

It is a very common problem that during presentation of any MS excel File we want to highlight active cell. There is some modules available but they might affect the format of your sheet.By adding this module to your sheet you can minimize this problem for example if you want to highlight the cell where you are working  as shown in figure1. 

for adding this feature to your excel sheet follow the steps Given below.

Step 1: Press ALT + F11 you will get the following screen
Step 2:Now Double Click on this Workbook and add following Module :
' Author Naushad Qamar
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
On Error Resume Next
Static OldRange As Range
Static OldIndex As Integer
Const movingColor = 6
If OldRange.Interior.ColorIndex = movingColor Then
OldRange.Interior.ColorIndex = OldIndex
End If
OldIndex = Target.Interior.ColorIndex
Set OldRange = Target
Target.Interior.ColorIndex = movingColor

End Sub
Step3:Now open your worksheet you will find active cell highlighted..
Step4: Now save File as Macro enabled as shown in figure :

Working sample Download
Please Do Comment and  give suggestions, moreover if you have any query,  feel free to ask.

Friday, June 4, 2010

Firm valuation (Monte Carlos Application)

For Firm valuation I used Monte Carlos Application.

For Monte Carlos Application I generated Random Values By using following macro
Sub montecarlos()
'This macro performed montecarlo simulations'
For rownum = 2 To 301

Range("b9").Value = Cells(rownum, 10).Value
Range("B11").Value = Cells(rownum, 11).Value
Cells(rownum, 13).Value = Range("c85").Value

Next rownum
End Sub
this Method will help to identify the riskiness of the project.
here is the link of complete template :
Monte Carlos Application Download link

Friday, January 8, 2010

GPA Calculator

After  Cliking on the given link you will see your iGoogle page like this:
for 1st semester.

Now You can Calculate your GPA:
If you have any repeat Course  then replace "No" with yoour Old GPA,for "F" insert "0" (zero)

Embeded or Add on your Blog or website just Copy paste the Code given below: