Data analysis toolpak in Macro

I am having trouble setting up the covariance data analysis toolpak in my macro. I am getting an error, “Covariance - input range missing”, after recording me doing the task.