Variables are named areas in memory where you store data while the workbook containing your code is open. If you've written Visual Basic code, you've probably already used variables without really thinking about it. Variables can be useful for keeping track of running counts, storing input from a user or another source, or storing a value that subsequent macro instructions will change.