Top Posters
Since Sunday
c
6
r
4
c
3
m
3
h
3
1
3
n
3
s
3
d
3
c
3
a
3
r
3
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Nakeiat Nakeiat
wrote...
Go to Answer
Posts: 325
Rep: 0 0
6 years ago
To refer to a particular object using VBA, the objects need to be referred to in their hierarchical structure. For example, to refer to cell A1 in a specific worksheet, the code would be ________.
A) Application.Workbook (workbookname.xlsx).Sheets("Sheet1").Range("A1")
B) Application.Workbook (workbookname.xlsx).Worksheet("Sheet1").Range("A1")
C) Application.Worksheet("Sheet1").Range("A1")
D) Application.Workbook (workbookname.xlsx).Worksheet(Range("A1"))
Read 35 times
2 Replies
Replies
Answer verified by a subject expert
shimilyshimily
wrote...
#1
Posts: 202
Rep: 37 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Nakeiat Author
wrote...
#2
6 years ago
Thank you
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1543 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 598
  
 1224
  
 894
Your Opinion
Who's your favorite biologist?
Votes: 608
Previous poll results: Where do you get your textbooks?