Cigar Asylum Cigar Forum - View Single Post

CigarNut · 07-11-2012, 11:19 AM

Not sure how to do this with a canned macro, but I can write a VB macro do do this... Something like this clears the contents of column 2, rows 1 through 100:

Sub cleanup()
Dim i
For i = 1 To 100
' this clears the cell, but you can use simple or regular expressions to edit.
Cells(i, 2).Value = ""

Next

End Sub

07-11-2012, 11:19 AM	#2
CigarNut Fck Cancer! Join Date: Jan 2009 First Name: Michael Location: Clermont, Florida Posts: 18,042 Trading: (111*)	Re: MS Excel cleanup routine Not sure how to do this with a canned macro, but I can write a VB macro do do this... Something like this clears the contents of column 2, rows 1 through 100: Sub cleanup() Dim i For i = 1 To 100 ' this clears the cell, but you can use simple or regular expressions to edit. Cells(i, 2).Value = "" Next End Sub __________________ Need Beads? Need Five Finger Bags? 2 of 3 Requirements for use of the CA Rolodex: 100 posts/ 60 day membership/ participation in trade (trader rating). New members can be added at any time.