Hello my friends.
Here's an example of my sheet
<tbody>
</tbody>
I have a command button, and i want to insert a vb code so every-time i press
that command button he finds the last empty cell on the column B but only between cells B4:B11 and fills that last empty cell with number "5". When he arrives the B11 cell he stops the filling (maybe can also appear a msgbox telling that isn't possible insert more values.
The B12 cell is always filled with the total value (can be a "0" when the range B4:b11 is empty).
Any ideas?
Thank's in advance
Here's an example of my sheet
A | B | C | D | E | F | G | |
1 | |||||||
2 | |||||||
3 | Lata | Vidro | Bolsa | ||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | Total | =SUM(B4:B11) | |||||
13 | |||||||
14 |
<tbody>
</tbody>
I have a command button, and i want to insert a vb code so every-time i press
that command button he finds the last empty cell on the column B but only between cells B4:B11 and fills that last empty cell with number "5". When he arrives the B11 cell he stops the filling (maybe can also appear a msgbox telling that isn't possible insert more values.
The B12 cell is always filled with the total value (can be a "0" when the range B4:b11 is empty).
Any ideas?
Thank's in advance