VBA ExceltoRight Function

Hi guys,

First post so first of all apologies if this is in the wrong section.

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.

welcome to the forum...
try the Office Development forum:

http://www.vbforums.com/forumdisplay.php?f=37

Will do.

Thanks.