select a range of cells using .Offset

**aloha31** · 08-06-2013, 05:11 PM

Is there a way to select multiple cells at once if referencing to a different cell? Something along the lines of:

Please Login or Register  to view this content.

This line of code gives an error and I'm looking for the proper syntax.

Thanks!

**JieJenn** · 08-06-2013, 05:14 PM

To select A1 and C1 together, this is what the syntax looks like. Range("A1, C1").select

**aloha31** · 08-06-2013, 05:16 PM

I am trying to select cell.offset(0,1) through cell.offset(0,6)

**JieJenn** · 08-06-2013, 05:18 PM

maybe try cell.resize(1,7).select?

**AB33** · 08-06-2013, 05:19 PM

May be

Please Login or Register  to view this content.

**aloha31** · 08-06-2013, 05:26 PM

Thanks, the .Resize function works like a charm!

Re: select a range of cells using .Offset