Task 4 - Selecting data using END

Learn how to select the cells with various exercises
Post Reply
User avatar
Mayank
Site Admin
Posts: 189
Status: Offline

Task 4 - Selecting data using END

Post by Mayank » 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