Excel: Select row(s) using a var

[vdennis]

If you want to select via your program the row(s) in an excel sheet, this code is helpful
def var RowToSelect as char no-undo.
def var RowNumber as integer no-undo.

assign
RowToSelect = string(RowNumber)
+ ':'
+ string(RowNumber).

hWorkSheet:rows(RowToSelect:select.

My program searchs the excel sheet by rows (RowNumber) looking for a blank value in a cell (say B42) and if the cell is null in value, will delete the row from the sheet.

 

[mrobles]

hWorkSheet:rows(RowToSelect):select

 

[vdennis]

hWorkSheet:rows(RowToSelect):select

What I was doing wrong was putting "'s as a part of the value. i.e row("12") I had set var = '"' + 12 '"'.
Thanks for getting back to me.