Ask a new question

Copy picture cells Excel 365 array formulas and VBA code needed

I have two named range columns, each in separate worksheets.  "fromPicCol" is a source column containing a combination of cells that either contain pasted pictures or are ="" blank cells. "toPicCol" is the destination column into which I want to copy only each fromPicCol cell with its contained picture.

 

Please provide an Excel Formula and VBA code snippets that accomplish the following without throwing #VALUE! Errors:

  1. =Does_Cell_Contain_Picture( "fromPicCol")  TRUE FALSE Boolean formula and VBA code snippet to recognize cells with pictures.

  2. =Copy_Picture( "fromPicCol")  formula and VBA code snippet

 

 I have wasted days trying to get CoPilot to develop either Formula or VBA solutions. CoPilot always answers with rejiggered code that still doesn't work.

 

I appreciate your assistance.

|

Could you share a test file with some dummy data in it? Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here. 

*Please make sure you have removed any sensitive or private information in the sample file before uploading. 

 

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 16, 2025 Views 27 Applies to: