Hi all,
I would really appreciate your help with one issue I've been dealing with.
The basic description of the problem is:
- I've got a column containing several cells that offer to choose relevant currency from the list (done by Data Validation list)
- I need to write a macro that would hide this column if required
& cleared all of the cells (both those, when user already selected currency from the list, as well as those still blank).
- If I hide the column and use ClearContents function to clear the particular cells, I get the blank cells. However, the problem is that Data Validation list isn't present any longer when I uncover the column again.
Would any of you had an idea what might be triggering this problem or what other function might be more applicable (some function mimicing the classical "delete" button on the keyboard).
Thank you very much for any help!!!
Bookmarks