I have a column that lists the days of the months. Every month has
different days with the corresponding dates. Is there a way I can get
all of the SUNDAY rows to be deleted?


---
Message posted from http://www.ExcelForum.com/

In an adjacent column enter =weekday(your date) and copy down for the
length of the list.
Where 'your date' is a reference to the dates in your list.

Tehn autofilter the range for values of 1 (that is Sunday).

Then delete the rows, then delete the column of =weekday() formulas.

Hope it helps.


---
Message posted from http://www.ExcelForum.com/

Is there a way to automate the process using VB Script?
I want to create a Command Button that if pressed, will delete al
sundays data (the rows from a1 to whatever cell)..

--
Message posted from http://www.ExcelForum.com

Sure it can be done, but I have no time now.

I will post back in a few hours (if someonelse does not get in first

--
Message posted from http://www.ExcelForum.com

try this
Option Explicit

Sub DeleteSundays()
Application.ScreenUpdating = False
Dim I
I = [a1].End(xlDown).Row - 1
Do
If WeekDay([a1].Offset(I, 0).Value) = vbSunday Then
[a1].Offset(I, 0).EntireRow.Delete
End If
I = I - 1
If I < 0 Then Exit Do
Loop While [a1].Offset(I, 0).Value 0 And I = 0
Application.ScreenUpdating = True
End Su

--
Message posted from http://www.ExcelForum.com

getting a VB error in command...
here's where the days start:
A7 all the way A37 are displayed as: 1/1/2004 and so on
B7 to B37 are the week days (monday, tuesday, etc...)

Can you help me revise your code

--
Message posted from http://www.ExcelForum.com