Sub Example1() Dim r as Range set r = range("A1:T65536") Msgbox r.rows.count End Sub()
Sub Example2() Dim r as Range set r = range("V1:AO34464") Msgbox r.rows.count End Sub()
I want to set a range that should carry 100000 rows. In short, I want to set data in the range V1:AO34464 exactly below A1:T65536 so that the total rows becomes 100000.
Is this possible? If yes, How?