VBA syntax help

[normpam]

Range("D3").Name = "ChkPart"
Range("ChkPart", Range("ChkPart").Offset.End(xlToRight)).Select

The code above I can use to select from “ChkPart” (or cell D3) through the cells with data to the right. What I would like to do is select the cells to the right beginning from E3.

I know the syntax Range(“ChkPart”).Offset(0, 1) could be used to move over one cell to the right, but within one VBA statement, how to get it to select from E3 to the right?

I’ve tried at least four different ways without success…. Ugghhh.


Much thanks. Have a great new year to all.

 

[normpam]

Following is a revised post... someone else had typed it in a bit incorrectly.

Range("D3").Name = "ChkPart"
Range("ChkPart", Range("ChkPart").Offset.End(xlToRight)).Select

The code above I can use to select from “ChkPart” (or cell D3) through the cells with data to the right. What I would like to do is select the cells to the right beginning from E3.

I know the syntax Range(“ChkPart”).Offset(0, 1) could be used to move over one cell to the right, but within one VBA statement, how to get it to select from E3 to the right?

I’ve tried at least four different ways without success…. Ugghhh.

 

[Norie]

Perhaps.

Range("D3").Name = "ChkPart"

Range(Range("ChkPart").Offset(,1), Range("ChkPart").End(xlToRight))

 

[normpam]

Awesome... thanks!! Works like a charm. I'm still studying it to try and understand why it works. If you could offer an explanation that would be even better! Very cool.