Mondi_2000
New Member
- Joined
- May 4, 2017
- Messages
- 7
Hi Forum,
I am trying to select a range of rows in a spreadsheet, via a macro.
My macro button is in the London 2017 cell.
Once I click on the button I'd like the macro to select Rows 2 to 5
Rows 2-5 are empty so I'm sure the code will include Select XLDown but that selects Row 6
I would like to use the same code to be able to select Rows 7 to 8 etc etc
I've looked at so much code but I've not found anything to help me.. I'm not trained in VBA so simple is best
Thank you in advance
Raymond
<tbody>
</tbody>
I am trying to select a range of rows in a spreadsheet, via a macro.
My macro button is in the London 2017 cell.
Once I click on the button I'd like the macro to select Rows 2 to 5
Rows 2-5 are empty so I'm sure the code will include Select XLDown but that selects Row 6
I would like to use the same code to be able to select Rows 7 to 8 etc etc
I've looked at so much code but I've not found anything to help me.. I'm not trained in VBA so simple is best
Thank you in advance
Raymond
1 London | 2017 | 2018 |
2 | 10 | 20 |
3 | 10 | 20 |
4 | 10 | 20 |
5 | 10 | 20 |
6 New York | 2017 | 2018 |
7 | 10 | 20 |
8 | 10 | 20 |
9 Sydney | 2017 | 2018 |
<tbody>
</tbody>