H.T.F.C.

		HTFC Forums > Software Newsgroups > Microsoft Office
how do I create a macro for 2 sheets

FAQ

06-12-2007, 01:32 PM

Niels

Posts: n/a

how do I create a macro for 2 sheets

I have a workbook with 2 sheets. On sheet 2 I have created a button to clear
the content of sheet 1 using a macro.
Sheets("Sheet1").Select
Columns("A:B").Select
Selection.ClearContents

When I run the macro it works but when I use the button it doesn't. What is
wrong??

Sponsored Links

Fix your Windows Problems - FAST.

FREE Safe Scan Registry Check. Locate & Fix Errors in Minutes!

www.Errorsweeper.com

« Can i install office on my laptop even though it is on my PC? | Unable to open an uploaded .docx file »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chart Macro	Beep Beep	Microsoft Office	0	05-25-2007 10:49 PM
Macro with autofilter	Lorna B	Microsoft Office	0	05-25-2007 03:33 PM
HP LaserJet 2100TN grabs multiple sheets of paper	Dan Lenski	Printers	4	05-11-2007 10:10 PM
Word Macro	Poppa Rotzee	Microsoft Office	3	04-10-2007 01:59 AM
Excel -Macro	Tina	Microsoft Office	0	04-05-2007 03:47 PM

All times are GMT. The time now is 12:35 PM.