Assign the content of a cell from excel to a variabele

  • Thread starter Thread starter Wesselius
  • Start date Start date
W

Wesselius

How do i add the content of a cell to a variabele within visual basic
 
var1 = Worksheets("Sheet1").Cells(1, 1).Value
or:
var1 = Worksheets(1).Cells(1, 1).Valu
 
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

Building SQL-string with vba 2
Assigning values from a selected range to individual variables 5
Photo in a sheet 6
Flling an array 10
Naming worksheets in loop 3
VBA set thick borders around non empty cells in range 0
Copying ranges 4
Update cell value while dragging UDF 4

Back
Top