Fill in the blank cells using a macro - cells are not actually blank

chess1984al

New member
Joined
Sep 30, 2013
Messages
1
Reaction score
0
Points
0
I have a specific file which includes cells that appear as blank. They are not though. This is probably cause in the past they contained some kind of formula or something else. the issue is that i need to feel in these cells with the value above.


I have attached the specific file and the cells I need to be filled in are the ones with a colored fill.


So the user chooses a specific area he wants to fill the 'blanks' -even if they are not actually blanks - and by pressing a button a macro works and fills everything.
 

Attachments

  • Dry_Skin_October_201309251718 _Metis Template.xls
    35.5 KB · Views: 14
Try this. select cells A12:E22 and click on the button.
 

Attachments

  • Dry_Skin_October_201309251718 _Metis Template2.xls
    42 KB · Views: 15
Back
Top