Results 1 to 3 of 3

Thread: VBA ExceltoRight Function

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    4

    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.

  2. #2
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    25,467

    Re: VBA ExceltoRight Function

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

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

  3. #3

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    4

    Re: VBA ExceltoRight Function

    Will do.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width