How to create test in Excel with VBA

We can create test data automatically in Excel using VBA. This data can be useful for many purposes like data analysis and calculations. In this video you will also learn how to create test data without VBA. Watch the training video below:

You can view this video also on YouTube.

Here’s the complete VBA for how to create test data in Excel with VBA:

Sub createTestData()
Range(“b1”) = “Jan”
Selection.AutoFill Destination:=Range(“B1:M1”), Type:=xlFillDefault
Range(“A2”) = “Item1”
Selection.AutoFill Destination:=Range(“A2:A11”), Type:=xlFillDefault
Range(“B2:M11”).Formula = “=RANDBETWEEN(10,50)”
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

End Sub


Leave a Reply

Your email address will not be published. Required fields are marked *