Macro to delete formulas extended past data set

How can I clear all the formulas after the last row of data. I have formulas in column k, l, and r.

remove formula

Please Login or Register  to view this content.

The previous code cleared everything in K, L, and R. I want to clear it after the last record. Not necessarily row 1821 because the number of rows will vary.

I was going to correct my code, but your data have crashed my Laptop 3 times.

It is a large file because of the formulas, which is why I want to try and get all those formulas out. Attached is a smaller file.

The last row in column K is 263, so do you want to clear cells after this row?

I want it to be deleted after the last row of data in column B. So row 165. But the row number will be various of where the last record is.

Please Login or Register  to view this content.

I get an complie error: syntax error. It is highlighting End (ClearContents End)

Well,
On the sample, I did not get any error.

This also work

Please Login or Register  to view this content.

It looks like it is working, but it is very slow. I can see why your computer crashed. At one time I tried to copy and paste values for the sheet and that crashed too.

You might have data downloaded from an applications, like SAP or Oracle.

It is data from SAP Netweaver.

You see I guessed correctly. I had answered a question on this thread where the data were exported from SAP and had crashed my PC.

Going forward, I suggest you should do the following:
When you copy data from non excel application, you should convert the data in to VALUES ONLY before you use the data.

Import in to excel, copy and paste values only and then you can do what ever you like in excel. If you just imported in excel, start working on the data, you will experience problems in the future.

thank you