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"

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"

If you don't want to use VBA, simply use this formula in the Excel cells:

=CHAR(34) & "load" & ROW() & CHAR(34)

Assuming that you want the list to start at row 1 that will work. If you
want it to start at row 5 for example, you'll need to change it to read:

=CHAR(34) & "load" & ROW()-4 & CHAR(34)

Drag fill this formula to complete your set and then copy and paste values
if you wish to remove the formulas.

"RevSri" wrote:

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"

or
="" & "load" & ROW() & ""

--
Don Guillett
SalesAid Software

"Dom_Ciccone" wrote in message
...
If you don't want to use VBA, simply use this formula in the Excel cells:

=CHAR(34) & "load" & ROW() & CHAR(34)

Assuming that you want the list to start at row 1 that will work. If you
want it to start at row 5 for example, you'll need to change it to read:

=CHAR(34) & "load" & ROW()-4 & CHAR(34)

Drag fill this formula to complete your set and then copy and paste values
if you wish to remove the formulas.

"RevSri" wrote:

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"

Hi
Highlight the three cells, with load1, load2 and load3 in them, and
click on the fill handle (small black cross as you hover over bottom
right of selected range). Hold your left mouse button down as you drag
the mouse down the column as far as required.
The ending number will increment automatically.

--
Regards

Roger Govier


"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"