What is mean by 'searchRange = "a1:hz500" ' define in help example

Hi Vijay.



You question addressed not to java (?) but to Excel cell addressing schema.

a1:hz500 describes coordinates of square region starting from first column (A) and first row (1) of a spreadsheet and ending with column named HZ and line number 500. Of course you are free to designate your own region for search.

For example, if you want to search within two first columns only and 150 lines down the search range should be a1:b150.