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 34 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
  1408 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 233
  
 550
  
 309
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 824
Previous poll results: Do you trust social media networks with protecting your privacy?