Check this article @ MS’s website to know where to get help for VBA programming. List of resources that are available to help you learn Visual Basic for Applications programming
Continue readingIf you want to convert a number to its equivalent letter, for e.g. 5 to E, you can use two approaches. 1. Insert this code in a Module and use this function ‘Author: Alan L. Lesmerises‘From: http://www.freevbcode.com/ShowCode.asp?ID=4303 Function ColumnLetter(ColumnNumber As Integer) As String If ColumnNumber > 26 Then ‘ 1st character: Subtract 1 to map the characters […]
Continue readingExcel Watch: An Official Excel Blog: “Probably the most common question the Excel team gets from our customers is ‘when are you going to add more rows/more columns/more rows and more columns’… Well, the answer to the question is ‘in Excel 12.’ Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns. That’s […]
Continue readingUsing this code you can add the same footer to all the worksheets in your workbook. It’ll ask you for Left, Center and Right footer. Please note that if you want to print all the worksheets with continious page numbers you’d have to select all the worksheets at the same time. This code will do […]
Continue readingCheck this web page for these forumals to do counts and sum. I didn’t know they had SUMX2PY2 kind of thing. Wow! Great!: “Summing up ways to add and count Excel data” If you want to See Add the product of corresponding values in multiple arrays SUMPRODUCT Add the square of each value in a […]
Continue reading