+ Reply to Thread
Results 1 to 4 of 4

Delete Specific Rows/Columns

  1. #1
    Registered User
    Join Date
    09-04-2008
    Location
    Singapore
    Posts
    24

    Delete Specific Rows/Columns

    Hi as stated, I would like to create a function to delete Specific range of columns/rows.

    Any idea if this is possible.

    Thanks

  2. #2
    Forum Contributor Kieran's Avatar
    Join Date
    10-02-2003
    Location
    Perth, Western Australia
    MS-Off Ver
    Office 2003
    Posts
    109
    Yes it is possible.

    It is difficult to provide further assistance without specific information regarding the seelction criteria for the rows/columns.
    Kieran

  3. #3
    Registered User
    Join Date
    09-04-2008
    Location
    Singapore
    Posts
    24
    If i were to use Forms:

    Prompt for the rows/column range criteria [Eg. Column A to G or Column E to F]
    Click Done

    Else is there any other way around.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    It would require VBA, so please post in the Programming forum.

    You could use Application.InputBox with Type=8, which requires entry or selection of a range.
    Entia non sunt multiplicanda sine necessitate

+ 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