hi

I have a button in "dm1" worksheet and when pressed i want it to clear the
contents in worksheet "input screen" d38 and e38

thanks in advance

cityfc, try this,
Sheets("input screen").Range("D38,E38").ClearContents

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"cityfc" wrote in message
...
hi

I have a button in "dm1" worksheet and when pressed i want it to clear the
contents in worksheet "input screen" d38 and e38

thanks in advance

Hi Cityfc,

Try:

'=============
Private Sub CommandButton1_Click()
Worksheets("Input Screen").Range("D38:E38").ClearContents
End Sub
'<<=============


---
Regards,
Norman



"cityfc" wrote in message
...
hi

I have a button in "dm1" worksheet and when pressed i want it to clear the
contents in worksheet "input screen" d38 and e38

thanks in advance

thanks for your help

cityfc

"Norman Jones" wrote:

Hi Cityfc,

Try:

'=============
Private Sub CommandButton1_Click()
Worksheets("Input Screen").Range("D38:E38").ClearContents
End Sub
'<<=============


---
Regards,
Norman



"cityfc" wrote in message
...
hi

I have a button in "dm1" worksheet and when pressed i want it to clear the
contents in worksheet "input screen" d38 and e38

thanks in advance