Hi,
I have created a "form" where you can put information into a number of fields, hit a "Submit" button and the information stacks up as a list below this form, I use the following code and works fine -
The list it stacks into I want to hide, however when I hide the rows where the list is, the 'stacking' doesnt seem to work anymore and only puts the information into row 37 each time and overwrites itself?
Please Login or Register to view this content.
Any ideas?
Thanks
Last edited by npsnps; 06-02-2016 at 09:38 AM.
Assuming that they're merged cells, try this:
Please Login or Register to view this content.
Last edited by xladept; 06-02-2016 at 10:24 AM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for the information but I cant seem to make this one work, it only moves the first box down (J9:O9) ?
Apologies, Ive managed to make it move all boxes but the same problem occurs, fine when unhidden, overwrites row when hidden?
Try this:
Please Login or Register to view this content.
Last edited by xladept; 06-07-2016 at 11:26 AM.
Comes up with the error - Run-time error 1004, cannot change part of a merged cell.
Uno Mas:
Please Login or Register to view this content.
Works beautifully, thank you for your help.
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks