Copy and Paste Cells contain formula only

[Mhabashy]

Hello
I need to minimize the Code, i have some cells having Formulas and some Have Validations and Some Having text,
I need a code to copy all the range but:
paste only formulas in the cells having formulas
Paste Validations in the Cells Having Validation
Skip the Blank and the Cells having text donot copy.

I am already using the following code its working but very long so the modifications is very difficult specially there are modifications every day so is there any way other than mentioned each cell.

Please Login or Register  to view this content.

[nankw83]

Hi Mhabashy,

Can you post a sample of your file to see how to best utilize the data to copy relevant cells as I don't see a clear pattern from your code

[Mhabashy]

I post a sample file , the formulas and validation lists is available at row number 10, every day i am changing this formulas and adding formula in some cells and removing from some, so to copy this in all the next rows without changing some cells i need to change the Macro cells references every time, so if there is any way in macro to detect if the cell is blank so skip it, if formula so paste formula only, if validation list so paste the validation list, without mentioned every address manual.

i hope its clear

thanks for your support

[nankw83]

Hi Mhabashy,

Try below code ... It basically checks every cell in row #10 & if it has a formula, copy it from row #14 until last row & same thing if the cell has a validation

Please Login or Register  to view this content.

[Mhabashy]

Thank you very much Mr. nankw83

I am so fortunate that you read my article
Your reply has saved a lot of work

thank you

[nankw83]

Happy to help & thanks for the Rep+

If that takes care of your question, please mark this thread as [SOLVED] from the Thread Tools above your first post