Row function Excel VBA

[mukhtar56]

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

[bakerman2]

Try this for starters.

Please Login or Register  to view this content.

[Rick Rothstein]

Here is another macro that you can try...

Please Login or Register  to view this content.