Macro - Fill Series Requires Two Rows of Data!?

Hi,

Thank you Frank for trying to help.

However, I have made the change you suggested, pressed the Button and it worked BUT when I pressed it again the Series fill does not work, the cell is just copied.

Can anyone Help - I seem so close, yet so far!

Thanks,

Paddy

Hi,

I have just tried that but that flags up issues on the next line.

Any other suggestions?

Ragards,

Paddy

Hi Paddy,

Here's a work-around for the version 2 problem.

First of all unmerge cell A4 so that it becomes cells A4 & A5, then type something (anything!) in cell A5.

Then change the third line of your VB code so that it reads:

Please Login or Register  to view this content.

i.e. 5 instead of 6 - this means that the region whose ".End" property is used begins in cell A5 rather than cell A6.

This produces the desired effect on the version you sent me.

I think that the basic problem is that in version 2, cell A6 is both the beginning and the end of a region (whose ".End" property is used). In version 1, cell A6 is the beginning of the region but the region ends at cell A7. Hope this makes sense.

Anyway, thanks for the feedback, good luck, hope this helps you out, but feel free to "call again" if there are further issues.

All the best,

Greg M

Yes, your help yesterday was perfect - thank you.

Basically the worksheet is intended to be filled in by each individual in the department. I had intended each person to have their own worksheet in the book and then a final department summary/total sheet.

The aim was to make a template worksheet so that any new recruits could be given and have their name assigned to a new sheet tab. (Hope that makes sense).

You can see the header, then the different types of data that must be filled in, then the indivuals summary (including monthly company card totals to check against statements). Each individual has their own purchase No. and it increments by 1 each order/purchase. I also wanted the sheet to make it easy for the individual to check they had filled in all the amounts (vat etc.) correctly.

The reason for the macro was to make it as simple as possible for the individual to add a new row without messing up formulas and continue their purchase No..

I hope that makes things more understandable. Thanks again for your help.

Regards,

Paddy

ps If all else fails I will have to work with what I have got and maybe have some sort of hiden? / blank line at A:6???

Thank you Greg and Roy for all your kind help.

Cheers,

Paddy

Hi again Paddy,

The attached version seems to do the trick. Glad to have helped so far.

All the best,

Greg M

Thanks,

Paddy