Select two different ranges by offsetting values

[viuf81]

Hi

I need VBA to be able to select two different ranges in excel at the same time. This is an example of what I would need to select:

Range("E6:P6,E4:P3").Select

The problem is that I only have the starting cell e.g.

Range("E5").Select.

from that I need to get to the above selection by using "offset" or another solution. I have the number of columns etc. I need to get the right offset value.

I've tried this:

Please Login or Register  to view this content.

But I get the message "Expected: List seperator or )"

Any ideas?

Thanks in advance
Thomas

[millz]

Try

Please Login or Register  to view this content.

[ragulduy]

maybe try this:

Please Login or Register  to view this content.

[ragulduy]

Or maybe:

Please Login or Register  to view this content.

[viuf81]

Thanks both of you... All solutions seems to work exactly as intended - GREAT Impressive with such fast response!

I'll try to see if I can find out how to give you all some points!

Have a nice day!