I have a list of types of expenditure arranged in a row with each row corresponding to a particular expense or outgoing.
Columns M,N,O are active - i.e right clicking them enables the user to assign a value in the earlier columns to a different type of expenditure
Right clicking an active cell displays only my customised options. Right clicking an non active cell displays the standard Excel options including copy and paste
I want to able to copy and paste data and formulae between the non active cells. If I either right click and copy or press the copy button, it seems that data is copied to the clipboard. The paste button becomes active, and there is the standard dashed flashing border around the cell. But when I click on the target cell, the paste button becomes inactive, the flashing border disappears and right clicking only shows a grayed-out Paste option.
I've tried to put the code you suggested in the immediate window but with no effect.
I'd be grateful for any other suggestions