Range Select Question

[ezywrap]

Quick Question

I'm trying to select a range on a worksheet

Range("A4:BL4").Select

The above will work but I can't get the syntax correct for the code below. I'm getting an error

Runtime error 1004
Method 'Range" of object '_Global' failed

Range("'A' & y & ':BL' & y").Select

Can someone point me in the right direction ?

Thanks

 

[Norie]

Why the single quotes?

Try this.

Range("A" & y & ":BL" & y).Select

By the way you don't normally need to use select when working with ranges.

 

[ezywrap]

Thanks that worked

You mentioned not using Select. What would be the alternative? Would something else be faster?

I'm only selecting these columns if a condition is met and pasting them into another sheet

Thanks

 

[Norie]

Well it really depends on the rest of your code.

Worksheets("Sheet1").
Range("A" & y & ":BL" & y).Copy Worksheets("Sheet2").Range("A1")

Also if this condition is based on a value in a cell you could use filtering.