If you want to change references of a formula, you could toggle F4 key inside the formula to change the references from Absolute, Column Absolute Row Absolute or all relative. Although, if you have to change references from a range, you can use these two options1. Download ASAP utilities, because it’s worth it, they have […]
Continue readingThis 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 reading