
Sarfaraz Ahmed
blogs from Delhi


During this post I will try to share VBA/Macro code to extract number from the text. Also, we will discuss the code to help you in understanding how to code in VBA. After all the aim is to make you enable write VBA code. Though in most of my post I write this at the end. This time I am advising you...
Posted on 19 August 2009 | 12:27 am
Read postIn this post, let's take a look at VBA code/function to concatenate string. Like in Microsoft Excel concatenate function you cant provide function with range. So you have to provide function with each cell at a time which is time consuming. The best solution to help VBA Code Function VBAConcatenate(...
Posted on 7 August 2009 | 1:46 am
Read postHuge reports with more than 5 sheets are very difficult to browse. Also, in spite of making very professional report you will it confusing. So, solution to avoid confusion is to add book mark sheet with link to each Microsoft Excel worksheet. This worked in my case with large number of reports. But...
Posted on 4 August 2009 | 12:35 pm
Read post