Data validation event

  • Hi guys,
    Could you please help me with the code, getting mess there..
    I'm trying to create an event, if data validation cell changes to "Yes" in "models" sheet being creating number of rows according to relevant qty.

  • Re: Data validation event


    Hi Jonny


    Do you think you could provide a file with data on the models tab. Not sure what you are trying to do when the code is referencing a blank sheet. You are trying to resize a named range but what does that blank sheet look like. Be much easier to count the data on that blank tab. I dunno - blank sheet. Too much guess work at this stage.


    Thanks


    Smallman

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!