Skip to main content

Posts

Showing posts from July, 2013

How to use Excel Sum Function in VBA

Sum Function using VBA Excel
What would be the first thing that you will do if you want to check how to code Sum function in VBA?
Record a Macro, of course and boom,  code in VBA is ready and done.
Recording a Sum macro in Excel, will have a code like this one below:
 ActiveCell.FormulaR1C1 = “=SUM(RC[-9]:RC[-2])”
Now the question is how to interpret this formula?
What if the range change or the requirements need a different cells location?
Record again a new VBA? I don’t think it’s a good idea.
The formula that Excel uses when you record isn't that hard to interpret.
You just need to get the hang of it.
Let's interpret the above excel formula.
 ActiveCell.FormulaR1C1 = “=SUM(RC[-9]:RC[-2])”
If you will just do a basic formula function, you can just type:
=SUM(Start_Range:End_Range)
The R1C1 formula follows same idea.
So, =SUM(RC[-9] is the start range and the RC[-2] is the end range.
RC[-9] means 9 columns before the active cell.
RC[-2] means 2 columns before the active cell and i…

Basic network monitoring tools

Basic network, monitoring tools and troubleshooting on Windows.
For those who have just embark on the field of Information Technology and even for those who are eager to learn on how to troubleshoot or do some network basic monitoring, Windows  has a lot of built in command to do this basic tasks.
In a small office or even in a large environment, there will always come a time that you will be disconnected to the internet  or even at your own home.
Basic or let's say common problem is unable to print, unable to connect to network share, unable to connect to "Facebook", or unable to connect to Google to find some programming code. Basically cannot connect to any websites on the internet and other things that user should do at home but love to do it at work.
Before we discuss on how to use those basic tools, let's define and discuss about two important and basic configuration on a local computer or workstation.
In every computer or workstation that is connected to the i…