Insert 1's in specific order each time I press a button

[daniel trats]

Hi, I need a simple macro for my project. So each time I press a button I want to insert the number 1 in a cell and like this consecutively. For example.... I press the button. I want number 1 to show up in cell d8 (without placing the mouse in this cell), then I press it again, so I want second 1 goes in d9, ...d17, then it follows row e...e8, e9, e10....e17, next 1 goes in f8,f9,f10,...f17....Notice there is a blank space in column i, o, u, y and af.

thank you (and sorry if it is a bit confusing)!

[JEC.]

How about

Please Login or Register  to view this content.

[daniel trats]

Thank you! It didn't work for me though. Should I put this in the modules? (I am not familiar with macros...). It shows 43663 in a random cell.. not sure what this means... Also I am working with 1904 data system, that might helps... not sure...

[JEC.]

Yes, open a new workbook. Insert a module with this macro in it. Theb keep running the macro.
It should work as expected

[daniel trats]

Excellent! it work perfectly, so happy