VBA ExcelToRight Help-VBForums
Results 1 to 3 of 3

Thread: VBA ExcelToRight Help

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    4

    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.

  2. #2
    Junior Member
    Join Date
    Feb 2012
    Posts
    17

    Re: VBA ExcelToRight Help

    Try

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

  3. #3

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    4

    Re: VBA ExcelToRight Help

    Quote Originally Posted by cholland3403 View Post
    Try

    Code:
    Range("A1").End(xlToRight).Offset(0, 1).Select
    That is exactly what I need.

    Thank you very much.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.