Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1 view
Skip to first unread message

Unknown

unread,
Feb 21, 2005, 9:17:02 PM2/21/05
to
How do you directly access cells in the worksheet, such as sheet1!a4 from a
visual basic procedure or function?

Unknown

unread,
Feb 21, 2005, 9:17:02 PM2/21/05
to
How do you directly access cells in the worksheet, such as sheet1!a4 from a
visual basic prodedure or function?

Myrna Larson

unread,
Feb 21, 2005, 9:28:24 PM2/21/05
to
X = Worksheets("Sheet1").Range("A4").Value

or

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

0 new messages