Hi Richard,
The area I am copying from (A2 in my example) is actually a list of posts which I am pasting into the calculation/area (A1:B1 in my example).
One by one or a group of posts but seldom the entire list.
The reason that I would prefer cut and paste that then would posts "automatically" disappear from the list when I've started processing them.
Kind regards Marcus
OK Marcus, understood.
I don't know why it works that way. Frankly I've never noticed before what I agree seems somewhat odd behaviour.
You could use the following simple macro attached to either a button or probably better make it a shortcut key combination like say Ctrl j , (just don't use one of the application reserved letters like say c, x etc.)
Sub CutWorkAround() Dim r As Range Set r = Selection Selection.Copy Destination:=Range("A1:B1") r.ClearContents End Sub
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks