This function will return random text (a-z) for the specified length. For ex. Randtxt(5) will return xythp. ‘—————————————————————————————‘ Procedure : Randtxt‘ DateTime : 10/23/2005 11:54‘ Author : Ashutosh‘ Purpose :This function will return random text for the specified no. of chars Function Randtxt(nochars As Byte) As String On Error GoTo Randtxt_Error If nochars = 0 Then Exit Function Dim sResult […]
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 readingSmart Computing Article – Basic Troubleshooting: “Whether Excel refuses to launch or just refuses to open a file, there are many steps you can take to restore the application to full working order. “
Continue reading