Row function Excel VBA

  • Dear Sir,







    I am new to VbA. I have a worksheet with a button to which I have assigned value "Star", when I click the button the value assigned enters column "B" from Row no 2.



    I want the value to start from Row 10 onwards or "B10" to "B21" only. The entry always starts from B2 only. How can I set the Row Range. Attached file.







    Thanks in Advance,



    Regards,



    Mukhtar

  • Please take a minute to read the forum rules, especially as regards cross-posting, and then follow them, Thank you!

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why