Offset to Right?

[liammoohan]

I have a sheet which has column headers on row2 each labelled as months in the corresponding rows below is the data associated with that month.

The problem I am having is that I am able to select cell A1 and get VB to go down and the select the next empty cell by usign '.Offset(1).Select' however I need to select cell 'A2' go to the right and then select the next empty cell on row 2.

Using '.Offset(1).Select' keeps putting me on the line below where I want to be - does anybody know how I can get around this?

 

[VoG]

Maybe like this

Cells(2, Columns.Count).End(xlToLeft).Offset(, 1).Select

 

[liammoohan]

.Offset(0, 1) works. Thanks.