Disable buffer clearing at a given cell format (NumberFormat = "m/d/yyyy")

Cross-posted at https://www.mrexcel.com/board/thread...macro.1215634/

Hello

I have a macro:

Please Login or Register  to view this content.

When copying (ex: may20, may-20) from another column to column A in Excel itself with this macro, it allows to paste only once - the next cell is no longer pasted, apparently the clipboard is cleared after the first paste. I have to copy again from another column. How it can be corrected?

There is no copy and no paste in this code. No idea what you are asking.

Also I would not assign Empty. If you want to clear the cell I suggest

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

There is no copy and no paste in this code. No idea what you are asking.

If I assign a value (NumberFormat = "m/d/yyyyy") by cells in column A using a macro (as in my case), then after that I cannot insert (for example: may20, may-20, etc.) from another cell into cells in column A more than once. For example, how copy mode is used in Excel. The cell copy mode is cancelled if the user starts editing the cell.


My macro was used to solve this problem:

I have dates as MonthYear, Month-Year (ex: May20, May-21 etc.) but I need them to be in dd.mm.yyyy format.

For example:
Aug20, needs to become 01.08.2020.
May-19, needs to become 01.05.2019.
Jul18, needs to become 01.07.2018.
Nov-17, needs to become 01.11.2017.
etc.

If enter something other than MouthYear, Mouth-Year, then nothing is entered into the cells, they remain empty.

I don't know what language is spoken in "World" but I think we have a language barrier because you started talking about copy/paste, yet you have still not show any code that does a copy or a paste, and then you talk about date formats, but I still don't understand your question.

If you are trying to convert date formats, which is completely unrelated to your thread title and first post, then maybe

Please Login or Register  to view this content.

But I suggest you attach a file with sample data and your code.

I suggest you attach a file with sample data and your code.

I cannot reproduce your problem. I run your macro on G7, copy G7, then paste it 5 times in various cells in column A.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link to your first post since you are a new member

Now I see what you are trying to explain. As you note in your first post, the problem is that when a macro starts to run, the clipboard is cleared. When you do a copy and paste using the worksheet interface, the Worksheet_Change event is triggered, clearing the clipboard. It doesn't matter what cell is changed; Worksheet_Change is called for any change. So you can't paste more than once. I will look further to see if there is a solution to this but I don't know of one offhand.