All Posts by n.ashutosh

2 Convert a number to its equivalent letter

If 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: Function ColumnLetter(ColumnNumber As Integer) As String  If ColumnNumber > 26 Then     ‘ 1st character:  Subtract 1 to map the characters […]

Continue reading

Excel 12 will have lots of columns and rows…

Excel 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 reading

2 How to create XY scatter plot in MS Access

Creating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot: Under forms tab, click New On the New form window select Chart Wizard and Select the table, which has your data, hit OK On the next screen, add two fields for which you want to plot […]

Continue reading

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 14 15 16 17 18 21