Hi,
It's been a while since I've used VBA
so I'm kind of stuck on this one.
I have a worksheet with 65 cells per page (5 columns, 13 rows).
And I have a userform, where I want to insert like number 28, and It would fill 28 cells on this page with the value from the userform.
What I'm doing is this:
And I don't know how to make excel calculate how many rows does it have to copy the same value in to get for exaple 28 cells with the same value.
It starts with A1 and goes to E1, then is should move down to the next row and go from A2 and so on.
Hope someone understands what I'm trying to do? 
Thank you!
Bookmarks