try this idea

Sub incrementnuminquotes()
For i = 1 To 3
x = """load" & i & """"
MsgBox x
Next i
End Sub

--
Don Guillett
SalesAid Software

"RevSri" wrote in message
...
my querry is that i want to gerenate the numbers automatically within the
quotes.(in excel)

For Example:

"load1"
"load2"
"load3"
like this i want to generate it upto "load1000"