what is wrong with the following statement:
Range("A2", Rows.Count).End(xlUp).Copy
I get a _global error. I want to select all the used cells in column A starting with A2.

thanks,