Adding an values to cells in a loop For..Next

Hi all

Someone know how to make that will be to able adding the same of value to a eg. 20 cells in a loop For..Next?

How to make the statement? How to declare it? Maybe some example of code?
Thanks in advance

maybe explain your question a little better.....i couldn't grasp what you wanted to do :confused:

VB Code:

for i = 1 to 20
      cells(i, 1).value = "something"    ' in rows if you want in cloumns change to cells(1, i)
next