Posted to microsoft.public.excel.misc

EAHRENS

Posts: n/a

Need help modifying a macro

I use the following macro to create a duplicate sheet.

Sheets("ICS 214").Select
Sheets("ICS 214").Copy Befo=Sheets(2)
'
End Sub

The problem is it copies the user inputted data from the first sheet rather
than giving me a blank section. How can I modify the macro so it will
automatically delete info in a range of cells such as d29-d46 on the newly
created sheet?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Editing a simple macro	Connie Martin	Excel Worksheet Functions	5	November 29th 05 09:19 PM
Modifying Macro	carl	Excel Worksheet Functions	3	August 25th 05 08:45 PM
macro with F9	Kenny	Excel Discussion (Misc queries)	1	August 3rd 05 02:41 PM
Make Alignment options under format cells available as shortcut	dforrest	Excel Discussion (Misc queries)	1	July 14th 05 10:58 PM
Playing a macro from another workbook	Jim	Excel Discussion (Misc queries)	1	February 23rd 05 10:12 PM

All times are GMT +1. The time now is 09:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us