Hello.

I am building a macro to add students to my class list (please see the "Count multiple numbers in a cell" thread) quickly. I've been learning since my last post and the macro does a few easy things quite well (I have never touched VBA until 2010). What the macro won't do is autofill. I need the macro to select the cells OPQ one row above the currently selected row and then autofill them down to the new row (student) I have defined. I can select the appropriate rage using RANGE and OFFSET but the line to autofill just never works.

I tried about 20 combinations and really searched google and this forum before I posted, but I'm stuck.

Thanks,
Josh