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
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