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”
Range(“B1”).Select
Selection.AutoFill Destination:=Range(“B1:M1”), Type:=xlFillDefault
Range(“A2”) = “Item1”
Range(“a2”).Select
Selection.AutoFill Destination:=Range(“A2:A11”), Type:=xlFillDefault
Range(“B2:M11”).Formula = “=RANDBETWEEN(10,50)”
Range(“B2:M11”).Copy
Range(“B2:M11”).Select
Selection.PasteSpecial Paste:=xlPasteValues
Range(“A1”).Select
Application.CutCopyMode = False

End Sub

 

Leave a Reply

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