All Posts by n.ashutosh

2 Random Text Generator

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 reading

1 Hide formula bar

Sometimes a formula becomes very long and it occupies lots of cells and it makes you crazy. So a better way would be1. Record a macro, give a proper name, description and most importantly define a shortcut key, different from Excel’s shortcut keys.2. Don’t record anything and stop the recording.3. Press Alt + F11 to […]

Continue reading
1 14 15 16 17 18 21