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

Dim Invoiceref
Invoiceref = ActiveCell.Value

Regards

Trevor


"Ulrik loves horses" <(E-Mail Removed)> wrote in
message news:6508B3BC-92AB-4D31-B685-(E-Mail Removed)...
> 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
>
>

Thanks Trevor

"Trevor Shuttleworth" wrote:

> Dim Invoiceref
> Invoiceref = ActiveCell.Value
>
> Regards
>
> Trevor
>
>
> "Ulrik loves horses" <(E-Mail Removed)> wrote in
> message news:6508B3BC-92AB-4D31-B685-(E-Mail Removed)...
> > 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
> >
> >
>
>
>