VBA macro: Copy to clipboard table range up to 0 in first column as criteria

[Josu]

Hello everyone
Maybe someone can share with an idea of macro, which will copy specific cell range to clipboard based on criteria of one column (if cell value is 0, copy to clipboard up to that 0)
Basically small example below, i need to copy all range from A4 to C12, so 12 rows, because row 13 in column A has 0. I am doing this manually, but it's takes for this to scroll down and i do this many times per day.
I tried hide cells with zero,but with ctr-shift-arrow down still takes hidden zeros
If there this can help for solution, in all of that cells is equal formula for some hidden cells. I don't know how make equal formula to leave cell blank is that hidden cell is also blank, it shows 0
Thanks i advance, hopefully my explanation is clear

Book1
	A	B	C
2	A	B	C
3
4	1	2	3
5	2	2	4
6	3	2	5
7	4	2	6
8	5	2	7
9	6	2	8
10	7	2	9
11	8	2	10
12	9	2	11
13	0
Sheet1

 

[Zot]

If you use macro to find last row like xRow = Range("A" & Rows.Count).End(xlUp).Row you will get 13 as expected. Then just minus one from that eRow to get the last row.