Task 4 - Selecting data using END

[Mayank]

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