Problem with Paste and Automatically repeating values - no fill ha
 

I have a large file with a small macro -uses crtl+l to run. In two of the
worksheets I cannot drag and paste series of dates (or numbers) based upon
the previous data. I checked the Advanced options and they are all checked
properly. The option works fine on all of the other worksheets (25). I
would appreciate any advice. Thank you

Problem with Paste and Automatically repeating values - no fill ha
 

"cannot" means what?

Error message? Nothing?

Can you select cells on those two sheets?

What has the macro got to do with it?


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 07:37:01 -0700, Hugh O'Brien <Hugh
wrote:

I have a large file with a small macro -uses crtl+l to run. In two of the
worksheets I cannot drag and paste series of dates (or numbers) based upon
the previous data. I checked the Advanced options and they are all checked
properly. The option works fine on all of the other worksheets (25). I
would appreciate any advice. Thank you