VBA macro to display table for values mentioned in cell A2 to cell B2 (if the values are changed in cell A2 and B2 then table should be generate)

[AmitSingh]

Hi,

Want to generate or display table for values entered in cell A2 to B2 cell. If the values of A2 and B2 cell change then table should be generated.

Tried with below code but didn't get desired output.

Option Explicit

Sub table()

Dim i As Integer
Dim j As Integer

For i = 2 To 4
    For j = 2 To 4
    Range("K4").Activate
    ThisWorkbook.Sheets("Table").Cells(j, i).Value = j * i
    Next j
Next i

End Sub

Thanks in advance for help.

Thank you!!

Regards,
Amit Singh

 

[vletm]

AmitSingh
Was there some kind of clear rule with Your given output?
... if was ... then I had to skip it ... where is Your named table?
One sample without any table...

 

[p45cal]

You can do this with a formula.
If you have the SEQUENCE function available to you:
in cell C4 (say):

=INDEX(SEQUENCE(B2-A2+1,1,A2),(INT((SEQUENCE((B2-A2+1)*10)-1)/10)+1))*(MOD((SEQUENCE((B2-A2+1)*10))-1,10)+1)

and if you have the LET function too:

=LET(from,A2,a,B2-from+1,size,10,b,SEQUENCE(a*size)-1,INDEX(SEQUENCE(a,,from),(INT(b/size)+1))*(MOD(b,size)+1))

In this last you only need 3 references/values (A2, B2 & 10).