About Us

I cannot get this to work.

"Don Guillett" wrote:

That IS the macro

--
Don Guillett
SalesAid Software

"Chris E." <Chris wrote in message
...
I don't understand where to put this in the macro.

"Don Guillett" wrote:

try this idea

Sub copytosheets()
For i = 3 To Sheets.Count
Sheets(i).Range("a1") = Range("a1")
Next
End Sub

--
Don Guillett
SalesAid Software

"Chris E." <Chris wrote in message
...
This is probably simple to do, but I don't do this enough to know.

How would I edit this macro to paste to a range of 134 worksheets that
are
after two that I do not want to paste to. In this example I have gone
to
each worksheet and pasted one at a time.

Range("G14").Select
Selection.Copy
Sheets("2").Select
Range("G14").Select
ActiveSheet.Paste
Sheets("3").Select
Range("G14").Select
ActiveSheet.Paste
Sheets("4").Select
Range("G14").Select
ActiveSheet.Paste

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro does not run when data refreshed	Larry Lehman	Excel Discussion (Misc queries)	0	January 16th 05 07:31 PM
HELP! How do you--> Lock a set of rows but also link worksheets to	FRUSTRATED	Excel Discussion (Misc queries)	6	December 29th 04 10:05 PM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM
Macro and If Statement	SATB	Excel Discussion (Misc queries)	2	December 3rd 04 04:46 PM
Macro for Show/Hide Range	Bill	Excel Discussion (Misc queries)	3	December 1st 04 05:33 PM

Menu

About Us