faboboren
11-22-2007, 12:30 PM
Hi Experts,
I have arrays in 45 sheets and 11 workbooks. Arrays are row variable, but they are fixed from A:M.
Rows are orderd by C column from # 1 to N, however after I applied a macro some of rows are deleted.
I am looking for a code to autofill C column from # 1 to the leftover rows.
Example:
original after delete after autofill
1 1 1
2 3 2
3 5 3
4
5
6
Thanks
I have arrays in 45 sheets and 11 workbooks. Arrays are row variable, but they are fixed from A:M.
Rows are orderd by C column from # 1 to N, however after I applied a macro some of rows are deleted.
I am looking for a code to autofill C column from # 1 to the leftover rows.
Example:
original after delete after autofill
1 1 1
2 3 2
3 5 3
4
5
6
Thanks