Hi I'm trying to fill cells for column F with formula and convert it to values but it take for more than one hour to do that!
Please Login or Register to view this content.
Hi I'm trying to fill cells for column F with formula and convert it to values but it take for more than one hour to do that!
Please Login or Register to view this content.
Give this a try
Please Login or Register to view this content.
HTH
Regards, Jeff
thanks for your answer but it also take a long time for filling cells what shall I do
Last edited by jeffreybrown; 02-04-2020 at 12:17 PM. Reason: Please do not quote full posts
Without seeing your sample file, it's hard to say; however, you may want to check the last row.
In other words, you may think the last row is row 100, but for some reason the usedrange in your spreadsheet thinks the last row is 900,000.
What happens when you select Ctrl + End? Does it go to the end of your data or further?
I'm still running the code ..
No It hangs too..
the last row is 300,000
Last edited by jeffreybrown; 02-04-2020 at 12:32 PM. Reason: Removed full quote.
Please do not quote full posts. I'm familiar with what I just said.
Your last row is 300,000, but what happens when you select Ctrl + End?
I'm not VBA expert, but my guess the formula is calculating all the way down the 300,000 rows is dragging your sheet down with it.
I would also suggest >> https://stackoverflow.com/questions/...-macro-running
but not sure that's the problem. Let me ask others to provide some thoughts.
when I select Ctrl + End the file (not responding) , is the problem that I used excel 32 bit for system 64 bits?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks