Pasting to single cell but still getting "not same size" error.

Check the offending cell and see if it is in fact a "merged" cell (format).

edited(didn't notice the xlright so I erased my VBA code.):

Try inserting a break on
Selection.Copy Destination:=Sheets("summary").Range("A4") and check the higlighted cells if it will fit the destination. check total number of columns and rows of the selected cells.

Good idea, but no, it's not a merged cell, and there aren't any in the document.

lasw10 said:

Check the offending cell and see if it is in fact a "merged" cell (format).

Click to expand...

GETTING THERE!

Your question made me think of something. When it doesn't work, the range I'm trying to select would be blank, so it would select the entire worksheet, which would cause problems of it's own. Duh! I am an idiot. Will try to fix that now. I added a check for that by inserting:

If Sheets("Phases").Range("B2") = "" Then GoTo BadJob

after my refreshall, and then it goes to the end and pops up a message box telling them that's a bad job.

It kinda works. I'm not getting any errors now, but my badjob catch only works on the 2nd time I run the macro, not the first. It appears that the refresh is happening after I get to this part of the code, even though I did a refreshall earlier in the macro. Is there a way to get it to wait until the refresh is done before going on in the macro? I tried using application.wait and it didn't do the trick (it waited, but paused the refresh too). Help????????????????


Thanks for the advice. I forgot to mention before that I'm a total idiot, at this anyway, generally I'm very smart. How exactly does one insert a break???


THANKYOU!!!!!!!!!!!!!!!!!!

aca_041 said:

edited(didn't notice the xlright so I erased my VBA code.):

Try inserting a break on
Selection.Copy Destination:=Sheets("summary").Range("A4") and check the higlighted cells if it will fit the destination. check total number of columns and rows of the selected cells.

Click to expand...

to insert break in VBA, click the line and press F9 button. You will see a red dot appearing on the left side.


Are you using an embeded object to refresh a data? I encountered this on one of the installed add-ins I have. The solution I did was to find if the embeded object has a default Sub like the one below. This ensures that VBA codes will only run after completion.

i.e.
Private Sub EmbeddedObject1_RequestComplete()
'insert codes after refresh
End Sub

Thankyou Aca. ( iPhone won't let me reply with quote...)

I don't quite follow what you said. For something to be embedded would I have he to embed it or does it happen by itself? Using Microsoft qwery and visual foxpro driver. Pulling data to a worksheet using arrays to consolidate data onto other sheets in the workbooks.

All I want is for my macro to run automatically whenever someone changes either cell a1 or b1 (these cells (date and job number) determine what info the qweries will return. I just need the code to wait for the refresh to finish.

Could you point me to info about or tell me how (exactly, remember I'm a newbie) I could embed something myself to do what you suggested. Thank you!