hello
i m using below code to fill formula but the processing is very slow need help
Please Login or Register to view this content.
hello
i m using below code to fill formula but the processing is very slow need help
Please Login or Register to view this content.
Turn OFF and Turn ON the events when writing to the cells, because on each change in any of the cell of that worksheet will call the change event and it will check whether the changing cells occurs in this range Range("E11:E1500") so this is the root cause of this issue which creates delay while inputting the data in cells.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
how above code works
when i enter data in E11. then column H10,J10,K10,L10........fill down the formula in column H11,J11,K11,L11
i want
now if i enter the data in E12 then formula fill from column H11,J11,K11,L11 not column H10,J10,K10,L10
something like this
Please Login or Register to view this content.
Hello S*2
plz read #3
thanx
Hello S*2
plz read #3
thanx
Try it like the below
Please Login or Register to view this content.
nothing is happening
Oops.. Change this line
ToPlease Login or Register to view this content.
Please Login or Register to view this content.
I think you mean:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Works fine
but the processing of fill formula is same as before, i mean very slow
same result : Very Slow
Turn off screen updating also and check
Please Login or Register to view this content.
Not working Same result again
BTW it will do
if possible plz
if i delete the E11 value then delete the all fill formula
Thanx a lot S*2
and also thanx a lot romperstomper
thread is closed
both of u i will add +1 reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks