How do I access worksheet cell data (i.e. cell sheet1!a4) from vi.

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

Guest

How do you directly access cells in the worksheet, such as sheet1!a4 from a
visual basic prodedure or function?
 
X = Worksheets("Sheet1").Range("A4").Value

or

X = Worksheets("Sheet1").Cells(4, 1).Value
 
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

Very Easy...Right? 14
Scattered array cells copy to scattered array cells another workbook 14
Another Easy Question 21
Copying Sheet1 to Sheet2 in a certain pattern 6
fill in data that is not empty 1
How to reference a cell from anther workbook without opening it 0
DropDown List (Validation) from other worksheet 7
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet 4

Back
Top