+ Reply to Thread
Results 1 to 2 of 2

selecting row from active cell selected

  1. #1
    Registered User
    Join Date
    08-07-2006
    Posts
    4

    selecting row from active cell selected

    Hi,

    If someone knows: I write the following (see below). and from the cells selected I would like to extend to the entire rows to delete them.

    Range("B" & ActiveCell.Row + 1 - decale).Select
    ActiveWindow.SmallScroll Down:=0
    Selection.SpecialCells(xlCellTypeSameValidation).Select

    Thanks in advance for any idea on this,

    Michael

  2. #2
    Mark
    Guest

    Re: selecting row from active cell selected


    Try this:
    Selection.EntireColumn.Select


+ Reply to Thread

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