Is there a way to copy Find and Replace contents?

[Tigerexcel]

As the title says can this be done? I've seen various internet posts that you select the data and then use Ctrl + C or some other copying method, as soon as I do that the actual contents are no longer kept and when I paste, there's nothing there.

 

[mole999]

any macros running, are you copy pasting on the same page

 

[shaowu459]

For language reason, I'm not sure if I understand you right.

 

[Tigerexcel]

any macros running, are you copy pasting on the same page

No macros running.

 

[Tigerexcel]

For language reason, I'm not sure if I understand you right.
View attachment 14744

Yes that is what I'm trying to do, but as soon as I try and copy, it doesn't allow me to do anything, it just pastes a blank cell.

 

[shaowu459]

Yes that is what I'm trying to do, but as soon as I try and copy, it doesn't allow me to do anything, it just pastes a blank cell.

Excel do not allow copy and paste multi selection which do not form a rectangle. If you want to do that, i assume vba is a must.

 

[mole999]

any hidden rows or columns

 

[Tigerexcel]

any hidden rows or columns

No hidden rows or columns.

 

[Michael M]

In the same workbook ??
AND as mentioned by @shaowu459, multiple selections must be a contigious range not random !!

 

[Tigerexcel]

Yes in the same workbook. These are non-contiguous ranges so I guess VBA is necessary which is ok if someone has a solution.