VBA write to cells to all tabs

[ghostexcel]

Hello all,

currently I am using this code:

Please Login or Register  to view this content.

I would like to find a similar code but that applieas to all tabs that I have in my workbook. Also, instead of writing to single cell (ex.: Cells(1,4), how can i write the data to first 1000 cells in one column (ex: first 1000 cells in colunn K).


Many thanks

[berlan]

With VBA for the first 1000 cells in column K across the sheets, try:

Please Login or Register  to view this content.

[ghostexcel]

Great! Many thanks!