adamsm
06-09-2011, 02:12 AM
Hi anyone,
I'm facing a situation where my workbook suddenly increased in size from 24kb to 1mb.
I have only four sheets in my workbook where one worksheet contains only formula.
I've tried the code in
http://www.vbaexpress.com/kb/getarticle.php?kb_id=83
But it does not work for me. I'm getting the debug message by highlighting the line
Do Until .CDo Until .Cells(j, k).Left > Shp.Left + Shp.Widthells(j, k).Left > Shp.Left + Shp.Width
Any help on this would be kindly appreciated.
Note: I"m using Microsoft Excel 2007
Thanks in advance.
I'm facing a situation where my workbook suddenly increased in size from 24kb to 1mb.
I have only four sheets in my workbook where one worksheet contains only formula.
I've tried the code in
http://www.vbaexpress.com/kb/getarticle.php?kb_id=83
But it does not work for me. I'm getting the debug message by highlighting the line
Do Until .CDo Until .Cells(j, k).Left > Shp.Left + Shp.Widthells(j, k).Left > Shp.Left + Shp.Width
Any help on this would be kindly appreciated.
Note: I"m using Microsoft Excel 2007
Thanks in advance.