clear only some content from row

[Chris1976]

Hi there , I have the code below that I use to create a second set of rows (3) when i click the command button. Everything works fine but the code ClearsContent in .Rows(lr + 3) totally. I only want columns "A", "F", "M", "Q", "R", "S", "T" cleared when it copies . Columns values "E", "U", "V", "P", "W", "X", "Y", "Z" should not be cleared. Any ideas

Please Login or Register  to view this content.

[TMS]

You could replace

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

[JLGWhiz]

maybe this:

Please Login or Register  to view this content.

[Chris1976]

Hi JLGWHIZ i get debug error on

Please Login or Register  to view this content.

[Chris1976]

Hi TMS, also get a debug on the second line

Please Login or Register  to view this content.

the first one clears tough

Please Login or Register  to view this content.

[JLGWhiz]

Hi JLGWHIZ i get debug error on

Would you want to share with us what the message says? I got no error when testing. Did you copy and replace the old code with the new code, or did you manually type in the changes?

[TMS]

No reason I can see that one would work and one wouldn't. Most likely a mistyped quote mark.

Nothing to test it with, so it's not tested.

[Chris1976]

Hi TMS, also get a debug on the second line

Please Login or Register  to view this content.

the first one clears tough

Please Login or Register  to view this content.

[Chris1976]

Hi JL

well the top part of the code needs to stay because that is a copy and paste function to a different sheet (transfer of date to Finding Summary Sheet) . The error below

Attachment 707116

sorry I did remove the lower sentence End With, there were two of those

and I noticed some of the cells were MERGED

It works 100% now, thank you JL

[Chris1976]

Just one last question, in Column A I have a Phot Pic, why would that not delete as well

[JLGWhiz]

Just one last question, in Column A I have a Phot Pic, why would that not delete as well

I am not really sure what you have in the cell. If it is an embedded graphic, then it is probably not in the scope of the 'ClearContents' function. But I don't work with graphics and have no expertise in that area. Yet it would make sense that graphics would be on a different plane than the text and formulas and would need a differenct method of removal.

[nigelog]

to remove pic in column A try

Please Login or Register  to view this content.