Results 1 to 5 of 5

User Prompt For Cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    13

    User Prompt For Cell

    Hi,
    I'm trying to write a macro and at one point I want it to stop at a user selected cell then delete all the values in the column below that cell and the same for the column to the left.

    This is the code I've tried to use to allow the user to select the cell, it comes up with with an input box but fails stating

    "method 'range' of object '_global' failed"\

        Dim sCell As String
        sCell = Range(Application.InputBox(Prompt:="Pick the Cell", Type:=8)).Value
        MsgBox sCell
    This should be really simple but it's not working and I'm pulling my hair out. Thanks in advance.

    Also attached is a graphic showing what I'm trying to do.
    Attached Images Attached Images
    Last edited by canyon289; 09-13-2011 at 03:29 PM. Reason: Corrected Typo in Code Tag

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