Shift:=xlDown problem

**bleeding_me** · 07-08-2010, 05:54 AM

Hello my friends,

I need some help here please.

I have a macro in VBA that is supposed to select a row, copy's the format and uses "Shift:=xlDown" to shift the cells down.

But i got a problem, when the line with "Shift:=xlDown" is executed, a dialog box appears (see attached image), can anyone help me to get rid of the dialog box?

This was working (the dialog box wasn't appearing), and now i don't know why it stopped working.

The code i have is this

Please Login or Register  to view this content.

**Andy Pope** · 07-08-2010, 06:06 AM

That would suggest the cells you are copying contain a reference to an external file which is not longer available. So the File dialog is displayed.

**bleeding_me** · 07-08-2010, 06:20 AM

Originally Posted by Andy Pope

That would suggest the cells you are copying contain a reference to an external file which is not longer available. So the File dialog is displayed.

Hi Andy. Thanx for your reply.

I went to see the formulas in that row and i found one in a column but it only refers to a sheet in the same workbook

Please Login or Register  to view this content.

No other formula in that row's columns.

And i tried deleting that formula and run the macro again, and the dialog box still appears

**bleeding_me** · 07-08-2010, 06:49 AM

Well i figured it out..

There were some links in the workbook that were broken, which i missed....

but your help was crucial to point me in the right direction

thanx Andy