-
Feb 23rd, 2012, 03:59 PM
#1
Thread Starter
New Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|