creating a macros and repeating it

's Computer Specifications

I have to replace certain values in a spreadsheet which then gives me new
calculated values. But the thing is I have to do this for 180 other
worksheets. Is it possible to create a macro substituting the values and
retrieving them. And then repating the process for the other 179?

's Computer Specifications

If the certain values are the same across all 180 sheets you could loop
through the sheets with one macro.

Provide some details on your data layout.

Gord Dibben MS Excel MVP

On Tue, 2 Dec 2008 04:31:00 -0800, fvs <(E-Mail Removed)>
wrote:

>I have to replace certain values in a spreadsheet which then gives me new
>calculated values. But the thing is I have to do this for 180 other
>worksheets. Is it possible to create a macro substituting the values and
>retrieving them. And then repating the process for the other 179?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Repeating macros x times?	VeryNew	Microsoft Excel Programming	0	14th Sep 2009 10:41 PM
creating repeating macros without programming language	bird lover	Microsoft Word Document Management	1	12th Nov 2008 07:54 AM
repeating macros	=?Utf-8?B?TGlzYQ==?=	Microsoft Excel Programming	0	27th Jul 2007 02:42 PM
How do I stop repeating Macros warnings at word startup	=?Utf-8?B?bWFydGlucjEyMQ==?=	Microsoft Word New Users	3	30th Jul 2005 02:55 PM
Creating Repeating Items	=?Utf-8?B?aG5kdGE=?=	Microsoft Access Forms	1	6th Aug 2004 02:16 AM