Task 4 - Selecting data using END

Learn how to select the cells with various exercises
Post Reply
User avatar
Mayank
Site Admin
Posts: 243
Joined: 06 Oct 2017, 11:19
Status: Offline

14 Oct 2017, 14:32

Download the file below:
Task 4 -marriage data.zip

Select the cell containing the word "Wife".

Now select the cell beneath it.

you should see that it selects Britney in cell B4.

 Now amend your macro so that it selects all of the brides (no matter how many there might be) using the END keyword:

task41.PNG

  Finally, amend your macro so that it selects all of the marriage data (from Britney down and across):

task 42.PNG


 Answer: 
Task 4 ans.zip




 
You do not have the required permissions to view the files attached to this post.
Mayank Goyal

Post Reply
Actuarial Blogs Insurology

icon icon