macro speeds
Niek
Already posted the code.
Want to look at the spreadsheet?
If so, how do I post it?
Thanks agaon
Under Pressure
"Niek Otten" wrote:
Post the code of your macro
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Under Pressure" wrote in message
...
| Under Pressure back online again looking for support.
|
| I have a small spreadsheet, 42 rows and 14 columns,with about 20 rows (195
| cells in total) of conditional formats, 6 graphics,lots of text, numbers and
| formulae.
|
| This forms a template that I need to copy 300 times so that data from a
| second spreadsheet can populate it. I have written a macro to do this.
|
| Something must be wrong because it takes far too long - to even copy half a
| dozen or so. I can use my mouse to copy and paste it faster.
|
| I've done the usual things like turn the autocalculate off and screen update
| off.
|
| My macro copies the first 42 lines and then uses a simple loop to paste it
| in the appropriate place under the original 42 lines.
|
| Any suggestions?
|