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
Any suggestions?Code:Range("A1").End(xlToRight).Select + 1
Thanks in advance.