# How to select random rows and cols from excel using QTP

• Questions
• How to select random rows and cols from excel using QTP
Tags:
Question ID: 104438
 ▲ 0 ▼ ♥ 0 How to select random rows and cols from excel using QTP Marked as spam Posted by deven21 (Questions: 1, Answers: 0) Asked on December 22, 2011 8:45 pm 4 views
 ▲ 2 ▼ ✔ Private answer I find it also helpful if you place the Randomize command before the Rnd call. This 'seats' the random number generator to avoid patterns. Randomize irow= Int((MaxRows * Rnd) + 1) Randomize icolumn= Int((MaxColumns * Rnd) + 1) Just a little tip Marked as spam Posted by rich-text (Questions: 2, Answers: 425) Answered on February 23, 2012 12:10 pm ▲ 0 ▼ ✔ Private answer Have you tried to use the Rnd Function? I have not done this but would think it look like this: `````` MaxRows = 10 'Maximum number of rows MaxColumns = 5 'Maximum number of columns sfilePath = 'pathe to Excel file isheet = ' Sheet to use irow= Int((MaxRows * Rnd) + 1) icolumn= Int((MaxColumns * Rnd) + 1) Set ExcelObj = CreateObject(''Excel.Application'') ExcelObj.Workbooks.Open sfilePath Set NewSheet = ExcelObj.Sheets.Item(isheet) value = NewSheet.Cells(irow,icolumn) ExcelObj.Application.Quit Set ExcelObj = Nothing `````` Marked as spam Posted by bubblehead712 (Questions: 2, Answers: 98) Answered on December 27, 2011 2:00 pm ▲ 0 ▼ ✔ Private answer Also if you set the sheet, you can use the vbscript to get the columns and rows for the sheet, then assign those to the appropriate max variables and use what is actually available on your particular sheet for true randomness for your particular sheet. Marked as spam Posted by Dan (Questions: 0, Answers: 709) Answered on March 1, 2012 2:01 pm