Run-time error when copying entire row!
On Monday, September 17, 2012 11:48:36 PM UTC+2, witek wrote:
Kieranz wrote:
Ben many thks. Will try that. Although couldn't understand what wrong with my code
Nothing is wrong.
It works fine.
However after you insert row, recalculation is triggered and something
else, somewhere else is crashing.
Try you code on empty workbook and check if it works or not. It should.
Try to switch to manual calculation and see if that works in you
application.
Generally using .select is not a good idea.
Witek and Ben
Yes, i have a protect some where in the code. Thks again K
|