"operation you are about to perform affects a large number of cells" then "Not enough available resources"

[HimanshuK]

Hi,

I have made a Team Timesheet Tracker file using vba and macros. The file size around 5.6 MB. With 5 sheets. Where there are macros in two sheets- say b1, b2 are "rest 3 - say a1, a2, a3" are capturing data inputs

We can input data in sheet b1 and macros are used to populate data in 3 sheets - a1, a2, a3. Then using macros in b2, I have created a dashbaord which inputs data from sheet a1, a2, a3.

when I am trying to delete rows from a1. It gives me above error.

Can anyone help me understand why? The file size is also very less.

I have tried to remove all the formatting from the sheet and also switch off autocalculate but that didn't help?

Looking for suggestions please.

I am using excel 2013

 

[ww4612]

can you share you code?
try to avoid delete range. you can remove the value in that range and move values below the blank row up with array.

 

[Michael M]

If you are deleting rows with VBA, are you deleting them from the lastrow upwards or starting at the 1st row and going down ??
Might be easier to simply post the code !!

 

[HimanshuK]

Hi, It is not a single code script, its multiple scripts. So I am not sure which one is actually causing the error.

It is difficult to share the complete workbook.

I am not deleting from last or the first column. I am trying to delete any random column.

And it is giving that error!!!