Selection too large

  • Thread starter Thread starter Brian
  • Start date Start date
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
 
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????).
 
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
 
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.
 
Back
Top