1 response
Take the variable and build a FOR loop, as in:
dim thecount as integer
dim thecounter as integer
thecount=cells(1,1).value
for thecounter = 1 to thecount
Do you code here
next
It is that simple. Pot some code, and we can help! Take a look at this article, it may assist you:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
dim thecount as integer
dim thecounter as integer
thecount=cells(1,1).value
for thecounter = 1 to thecount
Do you code here
next
It is that simple. Pot some code, and we can help! Take a look at this article, it may assist you:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba