Single Loop or Double?

Hi, in the attached excel spreadsheet I'm trying to generate a multiplication table with Macro to auto generate the cells in between the rows and columns but I can't seem to make the macro update for all cases (in the row). For instance, If instead I had integers 1-10 going from cells B5 to B15 instead of 1-5 from B5 to B10, I can't make the multiplication table also update to the 10th row as C10 to F14 are empty. One idea I had was to use nested for loops but I had no luck with that and it kept screwing up. Also I know that cells C5 to F5 are inputted well before the macro coding and this was intentional to allow macros to just copy down until the number of rows (which I want to know how to do). How do I make it so that no matter what I update cell B2 with it auto updates everytime macro is run.

Thanks

Hello selsunblue & Welcome to the Forum,

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...

Hi selsunblue,

Click on the "Edit" on your first post and then on Go Advanced to change your thread title to "Single Loop or Double?" Then look at the attached.

DoubleLoop Mult Table.xlsm

Hi selsunblue,

Sounds like a homework problem? Keep studying.. What grade do I get? If you don't want to vary the columns then set it equal to a number in the code. Give me a grade by clicking on the "* Add Reputation" below this post.

DoubleLoop Mult Table 2.xlsm