Results 1 to 8 of 8

Select next blank row

Threaded View

AldenH123 Select next blank row 12-14-2010, 05:41 AM
royUK Re: Select next blank row 12-14-2010, 05:57 AM
AldenH123 Re: Select next blank row 12-15-2010, 08:47 AM
royUK Re: Select next blank row 12-15-2010, 09:33 AM
DanExel Re: Select next blank row 12-15-2010, 09:36 AM
AldenH123 Re: Select next blank row 12-15-2010, 12:17 PM
royUK Re: Select next blank row 12-15-2010, 09:39 AM
royUK Re: Select next blank row 12-15-2010, 03:34 PM
  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Belfast
    MS-Off Ver
    Excel 2003
    Posts
    4

    Select next blank row

    Hi,

    how do I select next blank row?

    This is what I've tried... but over writes previously pasted data.

    Sub copyinvoicedatatosalesledger()
    '
    ' copyinvoicedatatosalesledger Macro
    '
    ' Keyboard Shortcut: Ctrl+q
    '
    Application.ScreenUpdating = False
    If Range("A2") <> "" Then
    Selection.End(xlDown).Select
    
    End If
    Sheets("Sales Ledger").Select
    Range("I2:N6").Select
    Selection.CurrentRegion.Select
    ActiveCell.Offset(1, 0).Range("A1").Select
    Range("I2:N6").Select
    Selection.Copy
    ActiveWindow.SmallScroll ToRight:=-2
    Range("A2:F6").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    End Sub
    Attached Files Attached Files
    Last edited by AldenH123; 12-14-2010 at 05:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1