i am not getting output with this code

[bhandari]

Sub usingthecolumns_androwsproperty_to_spcify_a_range()
Range("A1:B9, C10:D19").Rows.Count 
End Sub

iam not getting count with this code
OUTPUT SHOULD COME IN F3

 

[JoeMo]

Re: iam not getting output with thos code

Maybe:

Sub usingthecolumns_and_range_property_to_spcify_a_range()
Dim x, y
x = Range("A1:B9").Rows.Count
y = Range("C10:D19").Rows.Count
MsgBox x + y
End Sub

 

[bhandari]

Re: iam not getting output with thos code

Instead of giving X,Y

cant we use #1 code with the Msgbox?
Iam getting error"wrong number of argumrets andinvalid property assignment"

 

[hiker95]

iam not getting output with thos code

bhandari,

Try the following macro:

Sub usingthecolumns_and_range_property_to_spcify_a_range_V2()
' hiker95, 10/28/2017, ME1029096
Range("F3") = Range("A1:B9, C10:D19").Rows.Count
End Sub

 

[bhandari]

getting wrong answer @hiker95
result should come 19
as per your code iam getting=93

Sub usingthecolumns_androws_property_to_spcify_a_range_V2()
Range("A1:B9, C10:D19").Rows.Count = Range("F3")
End Sub

what's the differsnce if i use Range("F3") at end of the statement
y iam getting error?

 

[JoeMo]

bhandari,
Your range consists of two distinct areas. You must calculate the row count for each area separately, then sum the two counts.

 

[hiker95]

iam not getting count with this code
OUTPUT SHOULD COME IN F3

Bhandari,

You did not supply any raw data to test with.

The code I suggested worked in a sample workbook/worksheet with some raw data that I created.


In order to continue I would like to see your actual raw data workbook/worksheet.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[hiker95]

bhandari,

You do not have to supply your workbook/worksheet.

It looks like JoeMo has a solution for you to work with.

 

[bhandari]

Please find the attachment below
https://drive.google.com/open?id=0B-ZWlAv5DqaEWGl4UkZDMExPQk0

 

[hiker95]

Please find the attachment below
https://drive.google.com/open?id=0B-ZWlAv5DqaEWGl4UkZDMExPQk0

Bhandari,

I will not open your workbook/worksheet in your reply #9.


You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

If you are not able to use the above, then, I will not be able to assist you.