CRUTHERFORD
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 107
Hi,
So, I a have a command button set up which will clear certain cells. For example, in cells A1:A5 i have various numeric values and this command button clears contents. However, if I wanted to insert a row after cell A2, how can i get the VBA to incorporate all cells from A1:A6 or if i wanted to insert 2 new rows then A1:A7?
Thanks,
Cam
So, I a have a command button set up which will clear certain cells. For example, in cells A1:A5 i have various numeric values and this command button clears contents. However, if I wanted to insert a row after cell A2, how can i get the VBA to incorporate all cells from A1:A6 or if i wanted to insert 2 new rows then A1:A7?
Thanks,
Cam