Copy content of ActiveCell in a variable
 

Hi,

I would like to copy the content of an active cell in to a (text) variable
called Invoiceref.

Afterwards I want to combine this variable with another text variable to
come to a unique invoice reference

What would be the macro language to realize the copy into the first variable

Many thanks upfront

Copy content of ActiveCell in a variable
 

Dim Invoiceref
Invoiceref = ActiveCell.Value

Regards

Trevor


"Ulrik loves horses" wrote in
message ...
Hi,

I would like to copy the content of an active cell in to a (text) variable
called Invoiceref.

Afterwards I want to combine this variable with another text variable to
come to a unique invoice reference

What would be the macro language to realize the copy into the first
variable

Many thanks upfront

Copy content of ActiveCell in a variable
 

Thanks Trevor

"Trevor Shuttleworth" wrote:

Dim Invoiceref
Invoiceref = ActiveCell.Value

Regards

Trevor


"Ulrik loves horses" wrote in
message ...
Hi,

I would like to copy the content of an active cell in to a (text) variable
called Invoiceref.

Afterwards I want to combine this variable with another text variable to
come to a unique invoice reference

What would be the macro language to realize the copy into the first
variable

Many thanks upfront