Insert picture on blank colored cells and remove all picture

Hi Experts,

i have a worksheet that i need to insert picture which is colored yellow on blank cells by selecting button Insert picture from the range A1:AB1650 and if i need to remove all the picture by selecting button remove pictures.

The picture should be auto fit size according to the blank cell sizes.

Please see the attached file.

Hello Experts,

Please anybody help to solve this thread.

Hi Sintex,

Thanks you so much for your code. i tested the code i got the error on the line which is - "Set pic = ActiveSheet.Pictures.Insert(picName)" i place the picture in same folder path only even though picture not inserting.

Insert method need the complete path of image.

Replace row with:

Please Login or Register  to view this content.

Awesome its works perfectly thanks a lot.

one small request sir the yellow color blank cells finds only the pictures will insert right sir, if i change to other colors frequently on blank cells also i code to insert pictures so what code i need to use on it.

yes sir all blank cells only in range A1:AB1650. color its not a consider to insert the pictures.

yes after i tested code with my original file its working thank you.

There is two things need to solve it please help.

1. in have my master file there are some rows will be need to hide and unhide so when i hide the rows the pictures are not hiding it shows in all front of the first row. how to make if hide the rows also picture to hide it. see the attached picture.

2. when i select the remove picture button only in name of vanamo_logo.png should remove pictures and not to remove other name of the pictures in sheet like ( i have a header logo which is other name of pictures) its totally remove all pictures from the active sheet.

Hi sir,

i tested with your code the solve no:1 is solved its working perfectly.

The solve no:2 is not working its removed the other name of the pictures too.

sir i attached the my master file which i currently working for shift schedule for multi years to generate. Actually i need to be like this format. please check the file to solve the problems.

if clicking spin button to change years of schedule can you give me the code for that it will be more benefits and happy to me.

Hi sir,

Thanks for mention the wrong code after i replace the name of pic of both logo1 & logo2 the header pictures not removed working good but again i tested to remove the pic of vanamo_logo.png its not removing showing " Run time 13 error "

please advice what is wrong..

it is possible to show as single picture in blank cells not two picture in same blank of cells.

i will make solved the thread after this working and i will make new thread with spin create year calendar.

Hi sir,

Awesome its working thank you so much thanks a lot.

HI sir,

i need help to solve this issues again when i tried to inserted the pictures first on hide rows the pictures are not places on blank cells its shows all pictures on visible rows only. see the attached picture1

Then also i got noticed that Error message " Run time 13 error " on Remove_all Pic module because of activesheet first images not showing.

Ex: when active sheet i tried to insert the picture and after i hide the rows and giving delete pictures button then macro not delete the hiding rows of pictures, after i unhide the rows the pictures are remain there as look like attached picture2.

please could you solve this problems.