Selecting variety of ranges

[Mayank GoyalKeymaster]

Download the attached file

 First write a macro which selects the C in cell F1 shown below by its cell reference (your macro will have a single line).

 Now write a separate macro to select the blue area shown below:

[attachment=1]tsk11.png[/attachment]

Finally, write a macro to select the orange area using its range name orange:

[attachment=2]rask12.png[/attachment]

References: https://support.microsoft.com/en-us/help/244435/how-to-reset-the-last-cell-in-excel” class=”bbcode_url”>https://support.microsoft.com/en-us/help/244435/how-to-reset-the-last-cell-in-excel

[Author]

Posts