VBA ExcelToRight Help

Hi guys,

I have a small problem at the moment and wonder if any of you could help?

I have a row of information, let's say for arguments sake cells A1:A10 are populated.

On an hourly basis more information will need to be pasted to this row, into the first blank cell, so in this case cell A11.

I thought a simple way to do this would be a simple xltoright piece of code, however if I add + 1 to the end of this to select the next cell, it deletes the + sign and gives me an error message.

My code to try and select the next blank cell is simply

Code:

---

Range("A1").End(xlToRight).Select + 1

---

Any suggestions?

Thanks in advance.

Try

Code:

---

Range("A1").End(xlToRight).Offset(0, 1).Select

---

Quote:

---

Originally Posted by cholland3403

Try

Code:

---

Range("A1").End(xlToRight).Offset(0, 1).Select

---

---

That is exactly what I need.

Thank you very much.