code syntax

**lundy** · 07-14-2014, 12:05 PM

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,

**clabhart** · 07-14-2014, 12:08 PM

try

Range("A2", Rows.Count).End(xlUp).Select
Selection.Copy

**romperstomper** · 07-14-2014, 12:09 PM

You're missing part:

Range("A2", Cells(Rows.Count, "A").End(xlUp)).Copy

**stnkynts** · 07-14-2014, 12:19 PM

Another way of writing the same thing:

Range("A2:A" & Rows.Count).End(xlUp).Copy

**shg** · 07-14-2014, 01:04 PM

Originally Posted by stnkynts

Another way of writing the same thing:

Range("A2:A" & Rows.Count).End(xlUp).Copy

That doesn't work for me.

**stnkynts** · 07-14-2014, 01:33 PM

Originally Posted by shg

That doesn't work for me.

Woops. Had a moment there. Should have been

Range("A2:A" & Range("A" & Rows.count).End(xlUp).Row).Copy

**lundy** · 07-14-2014, 01:14 PM

thanks guys

Re: code syntax