Copy content of ActiveCell in a variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign Selection to a Variable 2
Simple Variable to someone 5
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Variable Range Copy... 13
Copy contents of variable into clipboard 6
referencing the activecell 4
VBA code for for telnet 1
How do i refer to cell contents in a macro? 1

Back
Top