All Posts by n.ashutosh

1 Excel Training Materials

Years ago I conducted an Excel training session for Ohio Association for Institutional Research and Planning (OAIRP) and I used the following material for that Excel training: Exercise file for Excel training Excel Formulae Excel training handout

Continue reading

Excel Books

Books on my shelf: Professional Excel Development by Stephen Bullen, Rob Bovey This is by far the most authoritative book on Excel development from Add-ins to APIs. A word of caution though, it is not for the beginners. Excel Advanced Report Development by Timothy Zapawa Ever wondered on using Excel as a report development tool? […]

Continue reading

1 A function to reverse a string

Very simple, uses the VBA function StrReverse to reverse the input string. ‘A function to reverse a string provided as input‘For example, the string “abcd” will become “dcba”‘Uses the VBA function StrReversePublic Function ReverseString(sInputString As String) As StringOn Error GoTo ReverseString_Error    ReverseString = StrReverse(sInputString)    Exit Function ReverseString_Error:    ReverseString = “#ERROR#”End Function

Continue reading
1 12 13 14 15 16 24
>