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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I access worksheet cell data (i.e. cell sheet1!a4) from vi. (https://www.excelbanter.com/excel-programming/323724-how-do-i-access-worksheet-cell-data-i-e-cell-sheet1-a4-vi.html)

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

How do you directly access cells in the worksheet, such as sheet1!a4 from a
visual basic prodedure or function?

Myrna Larson

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

X = Worksheets("Sheet1").Range("A4").Value

or

X = Worksheets("Sheet1").Cells(4, 1).Value

On Mon, 21 Feb 2005 18:17:02 -0800,
wrote:

How do you directly access cells in the worksheet, such as sheet1!a4 from a
visual basic prodedure or function?

All times are GMT +1. The time now is 11:50 AM.