How to increase numbers for value in Excel

[Jyobtech]

Hi Experts,
In my regression data sheet(.xls), Everytime new value has to provide.
For example Right now I have the value in data sheet like "BUNA17" , and want to increase this value BUNA18,BUNA19,BUNA20... etc by using function in excel.
If I use RANDBETWEEN function,it gives random numbers but I want that random number uniquely(same number can't be used next time)

Please helpme out.

[Ankesh]

why dont you use a loop and keep incrementing the value! You can use any loop. Below is a sample loop.

Code:

For i=1 to 10
strVal="BUNA"&i
'Write value to excel
Next

Regards,
Ankesh

[Jyobtech]

Thanks for response Ankesh,

I am not writing the values in my excel sheet.(I should update the values in excel before the every script execution,otherwise the script will fail.Is there any method insipte of manual updating the values in excel)

I want to do the logic in EXCEL only .
Example in excel column =RANDBETWEEN(10,30) gives only vales between 10 to 30 . I want the same values not in randam order ,it should be countinuesly(Is there any function in excel)