Selection too large

B

Brian

I am using copy and fill down as part of a macro and am
receiving this error message. Can someone tell me what I
am doing wrong? This macro was working fine all day
yesterday. TIA
 
D

Dave Peterson

I've never seen this message, but it sounds like your selection is too large
<vbg>.

Does your macro copy/fill multiple columns down?

If yes, maybe you could do it with fewer columns (one column at a time????).
 
B

Brian

yes, I am trying to copy and fill down eight columns. I
have tried them one at a time with no luck and I even
tried to copy/paste special thinking that if I got the
formula out of there it might help, but still no luck. I
noticed that when I received the error message in my vba,
I would end it, and then tried to copy and fill down
myself, but nothing would happen. The destination cells
showed nothing, not even the formula. Any other ideas?

TIA
 
D

Dave Peterson

Maybe you could just assign the formula to the whole range at once. I'm not
sure if that will pass muster, either.

range("a1:a9999").formula = "write your formula using A1 as your reference"

It'll work just like selecting a1:a9999 and then typing the formula and hitting
ctrl-enter.

If that doesn't work, how about filling half way down, then do it again to get
the last half.
 
Top