Use macro to add 1 to a cell

[Jazzmanstereo]

Hi, just wanna know how to add one to a cell within excel using a macro.

This cell is the order number, so once the order is processed i want it to add one to the order number.

Anyone help me out? pleaze

[Jay Petrulis]

On 2002-04-09 10:45, Jazzmanstereo wrote:
Hi, just wanna know how to add one to a cell within excel using a macro.

This cell is the order number, so once the order is processed i want it to add one to the order number.

Anyone help me out? pleaze

Hi,

After your order processing routine is complete, insert the following

Range(your cell) = Range(your cell) + 1

example:
A1 is the order cell
Range("A1") = Range("A1") + 1

Bye,
Jay

[nt82]

wg

[trovello]

Similar but Different question: I am trying to add a 1 before each number of a column of telephone numbers using a macro. i.e. the numbers are 5555551212 and I need them formatted as 15555551212.
When the numbers end in the column (it changes constantly), the macro should end.