Hi, I'm trying to create a multiplication table from user input to an Excel worksheet. I want my startValue to End Value to go down column one, and across each column.
I can get the correct values to print across the screen (vice verse) when I use one loop at a time, but when I put them together, the numbers are whacky. Here's my code:
For Row = StartValue To EndValue Step 1
For Column = StartValue To EndValue Step 1
Multiply = Row * Column
Cells(Row, Column).Value = Multiply
Next Column
Next Row
I've tried declaring and using new variables for the cell placements but that didn't work for me. I really appreciate all the help I can get. Thanks in advance!
Bookmarks