How to count rows with a blank space

[adiacal7]

hi guys

i have a problem could you all help me please for count rows with a blank space

example like this

i have coloumb wih data and archive i just want to count rows for table data only in vba macro so i can copied that data in new coloumb

archive
1
1
1
1


data
1
1
1
1
1


thanks guys

 

[My Aswer Is This]

You want to copy all the cells in column "B" with data and Put these values where?

 

[adiacal7]

yeah bro i want to copy to new worksheet,, nb row in data maybe its not same if i collect raw data

 

[My Aswer Is This]

I need exact details. When you say "yeah bro i want to copy to new worksheet

That's not specific at all.

What Worksheet? Give me a Worksheet name. And where on the Worksheet.

 

[adiacal7]

I need exact details. When you say "yeah bro i want to copy to new worksheet

That's not specific at all.

What Worksheet? Give me a Worksheet name. And where on the Worksheet.

im sorry

i have a worksheet with sheet name is Data and i have data as like this

Data
1
1
1
1
1

archive
1
2
1
2
1
2

i want to copy "Data" in new worksheet without "archive"
so i confused for vba code for count rows at "data" (Just row at :data: before blank cells)
i'm already test this code its not work properly

Dim c As Long
c = Cells(Rows.Count, "B").End(xlUp).Row
Range("A1:N" & c).Select Selection.Copy

yeah i mean that code is count how many Row Coloumb B and not count only Rows at " Data"

could you please help me?? thank mate

 

[My Aswer Is This]

I'm sorry I'm not able to understand what you want. Maybe someone else here at Mr. Excel will understand what you want.