Task 4 – Selecting data using END

Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Task › Macros › Selecting cells › Task 4 – Selecting data using END

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • October 14, 2017 at 9:02 am #22751
    Mayank Goyal
    Keymaster

      Download the file below:

      [attachment=2]Task 4 -marriage data.zip[/attachment]

      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:

      [attachment=0]task41.PNG[/attachment]

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

      [attachment=1]task 42.PNG[/attachment]

       Answer: [attachment=3]Task 4 ans.zip[/attachment]

       

    • Author
      Posts
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.

    Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Task › Macros › Selecting cells › Task 4 – Selecting data using END