Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 863
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move cell data to another worksheet cell automatically. Alan New Users to Excel 3 April 6th 08 08:05 PM
Use data from access in a cell BMC Excel Discussion (Misc queries) 1 September 5th 07 12:36 PM
Cell entry to access Worksheet Roberto[_2_] Excel Discussion (Misc queries) 2 July 20th 07 09:24 PM
Using cell content to access another worksheet in same workbook ScubaBum Excel Worksheet Functions 5 June 28th 06 11:11 PM
selecting a cell in sheet1 paul mueller Excel Programming 1 November 18th 03 09:15 PM


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"