command button coding to delete column values

**mubashar** · 01-10-2014, 01:09 PM

i need coding in a command button ie in commandbutton1_click()
when i click the command button , values from cell A4 to the last filled cell are all deleted, leaving them empty cells.
thanks

**gsnidow** · 01-10-2014, 01:18 PM

Maybe this?

Sub Button1_Click()

    Dim rng As Range
    
    Set rng = ActiveSheet.Range("A4:A" & Range("A" & Rows.Count).End(xlUp).Row)
    
    rng.Value = ""
    
End Sub

Greg

**mubashar** · 01-10-2014, 02:38 PM

thanks, it works perfectly

command button coding to delete column values

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

command button coding to delete column values

Re: command button coding to delete column values

Re: command button coding to delete column values

Thread Information

Users Browsing this Thread

Similar Threads

Coding Search and Update Command Button in an UserForm

[SOLVED] Delete a VBA Command Button after run?

coding a command button to open a particular worksheet

Delete command button ?

Delete a command button via VBA

Bookmarks

Bookmarks

Posting Permissions