Results 1 to 6 of 6

Help with Code for clearing a column please

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    bc canada
    MS-Off Ver
    Excel 2010
    Posts
    40

    Help with Code for clearing a column please

    Hi
    I created a button to clear text in a column.
    every time I try recording a macro for it I get different results
    I would like to clear text in column B from B3 down

    Thia is my last attempt
    Sub ClearInfoB()
    '
    ' ClearInfoB Macro
    '
    
    '
        ActiveCell.Offset(-23, 0).Range("A1:A52").Select
        Selection.ClearContents
    End Sub
    It puts me half way down Column D witch is blank
    What do I change


    TIA
    Last edited by Leith Ross; 06-16-2013 at 01:41 AM. Reason: Added Code Tags

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