Posted to microsoft.public.excel.misc

M.A.Tyler

external usenet poster

Posts: 100

Adjusting Macro

Can the following macro be adjusted to NOT clear the 1st rows of pages 1, 5,
7 and 8? This is where the headers are, and they are used in other formulas.

Thanks.

M.A.Tyler.

Sheets("Sheet7").Select
Cells.Select
Selection.ClearContents
Sheets("Sheet8").Select
Cells.Select
Selection.ClearContents
Sheets("Sheet5").Select
Cells.Select
Selection.ClearContents
Sheets("Sheet1").Select
Range("P245").Select

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
Adjusting Referances	Lanza52	Excel Worksheet Functions	0	August 21st 06 12:49 AM
Adjusting Formula	Jasmine	Excel Worksheet Functions	0	June 6th 06 02:24 PM
Macro / VBA adjusting variable columns	PaulW	Excel Discussion (Misc queries)	1	April 23rd 06 08:25 AM
Adjusting Date Results	JoeKazz	Excel Worksheet Functions	7	September 10th 05 06:42 PM
Auto Adjusting Text Box	Jae	Excel Discussion (Misc queries)	0	August 11th 05 06:19 PM

All times are GMT +1. The time now is 08:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us