Recent content by afoster

It works! Thank you so much. I noticed that if I enter any information that requires a number of payments over 20, the month column (Column B) populates, but columns C, D and E do not populate beyond row 20. Can that be corrected and if so how do I do it? Thanks, it does work, but it does not...

It works! Thank you so much. I noticed that if I enter any information that requires a number of payments over 20, the month column (Column B) populates, but columns C, D and E do not populate beyond row 20. Can that be corrected and if so how do I do it?

I have set up another spreadsheet from the start and only added the vba code for the module before entering the vba code that goes into the Sheet1 area. When I enter the formula =GenerateSequence(H7) it only adds the number 1 in the first cell of the B column, directly under the heading Month...

My version of Excel is 2010 and I am wondering if that is the cause of the error messages and problems I am having getting this to work.

In following your second directions, I get the following error message when I try to copy the value in cell b5 to b24. I also get the same error message when I try to change any of the values in column H of your solved spreadsheet.

In following your second directions, I get the following error message when I try to copy the value in cell b5 to b24. I also get the same error message when I try to change any of the values in column H of your solved spreadsheet.

Thank you so much for your help. I am still having trouble thought and I imagine is that I am not doing it right. Which cell do you mean when you say "Select intended cell" in number 4. Also, even though I add the code for the module, there is no listed module when I view the macros. Is it...

I have followed the instructions in How To Create a Credit Card Payment sheet and everything is working except that the rows are not hidden if the value in column b is empty. This is because the tutorial uses the Sequence function and my version of Excel does not allow the sequence function...