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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select drop down menu option using libre-calc macro 0
Macro to Close a specific workbook. 1
Run Macro If Cell have "x" value 0
Selection Too Large 1
The picture is too large and will be truncated."-excel Warning 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
macros 3
Recording new Macro won't reset drop downs 3

Back
Top