Good Morning all - (well it was a good morning until i got out of bed!)

I have been using a workbook for months without any problems and this
morning....not working.

The only piece of code that i have changed is changing the background of a
commandbutton when it is pressed.

The code is:

Private Sub CommandButton3_Click()
CommandButton3.BackColor = vbRed
CommandButton1.BackColor = vbRed
Call clear_old_locates
End Sub

Private Sub clear_old_locates()
Sheets("MS").Select
Columns("E:I").Select
Selection.ClearContents
End Sub

When it reaches the "Columns("E:I").Select" i get an error.

"Run-time error '1004';
Application-defined or object-defined error"

I have tried changing the way i select the column using ranges, etc but
still get thrown out errors...

Any ideas?!

Thx


Richard

--
__________________________________
HTH

Bob

"Richard Edwards" wrote in message
...
Good Morning all - (well it was a good morning until i got out of bed!)

I have been using a workbook for months without any problems and this
morning....not working.

The only piece of code that i have changed is changing the background of a
commandbutton when it is pressed.

The code is:

Private Sub CommandButton3_Click()
CommandButton3.BackColor = vbRed
CommandButton1.BackColor = vbRed
Call clear_old_locates
End Sub

Private Sub clear_old_locates()
Sheets("MS").Select
Columns("E:I").Select
Selection.ClearContents
End Sub

When it reaches the "Columns("E:I").Select" i get an error.

"Run-time error '1004';
Application-defined or object-defined error"

I have tried changing the way i select the column using ranges, etc but
still get thrown out errors...

Any ideas?!

Thx


Richard

Me too, but this works


Private Sub clear_old_locates()
Sheets("MS").Columns("E:I").ClearContents
End Sub

--
__________________________________
HTH

Bob

"Richard Edwards" wrote in message
...
Good Morning all - (well it was a good morning until i got out of bed!)

I have been using a workbook for months without any problems and this
morning....not working.

The only piece of code that i have changed is changing the background of a
commandbutton when it is pressed.

The code is:

Private Sub CommandButton3_Click()
CommandButton3.BackColor = vbRed
CommandButton1.BackColor = vbRed
Call clear_old_locates
End Sub

Private Sub clear_old_locates()
Sheets("MS").Select
Columns("E:I").Select
Selection.ClearContents
End Sub

When it reaches the "Columns("E:I").Select" i get an error.

"Run-time error '1004';
Application-defined or object-defined error"

I have tried changing the way i select the column using ranges, etc but
still get thrown out errors...

Any ideas?!

Thx


Richard

fantastic. thanks very much.

how odd - as i say it had been working for months...

have a good day.

rich

"Bob Phillips" wrote in message
...
Me too, but this works


Private Sub clear_old_locates()
Sheets("MS").Columns("E:I").ClearContents
End Sub

--
__________________________________
HTH

Bob

"Richard Edwards" wrote in message
...
Good Morning all - (well it was a good morning until i got out of bed!)

I have been using a workbook for months without any problems and this
morning....not working.

The only piece of code that i have changed is changing the background of
a commandbutton when it is pressed.

The code is:

Private Sub CommandButton3_Click()
CommandButton3.BackColor = vbRed
CommandButton1.BackColor = vbRed
Call clear_old_locates
End Sub

Private Sub clear_old_locates()
Sheets("MS").Select
Columns("E:I").Select
Selection.ClearContents
End Sub

When it reaches the "Columns("E:I").Select" i get an error.

"Run-time error '1004';
Application-defined or object-defined error"

I have tried changing the way i select the column using ranges, etc but
still get thrown out errors...

Any ideas?!

Thx


Richard