Try this :
not working brother
Please explain what "not working" means.
- Does the code run?
- Does it run but do nothing?
- Does it produce error messages? If so, what do the messages say?
- Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
- Does it hang?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
after click the button, this error showing
for this code
rws = .Cells(.Rows.Count, "A").End(x1Up).Row
Attachment 633173
Don't think you copied/pasted the code. You have a 'one' in xlUp instead of an 'el'.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
i didnt understand what the problem but
i write the code munally because u sent it as a photo, how can i copy the text
Yep, you are right. Don't know why vorucha sent as a picture.
Sounds like you didn't understand my comment. xlup (eks-el-you-pee) not x1up (eks-one-you-pee)
Last edited by Pauleyb; 07-19-2019 at 11:26 AM.
Hi bro, You have also posted photos ...
How did I "copy something as text" from photos for the trial code ?
I have no OCR.
... and you can change the whole macro to this code below, it will be "more flexible":Please Login or Register to view this content.
Please Login or Register to view this content.
fantastic code , but there two problems ( its work only if i add more rows )Please Login or Register to view this content.
1 - if i have same number of rows in the photo in first comment, noting happen even if its filled - it should clear contents -
2 - also if i have less rows than the first photo, noting will happen even if filled - it should clear contents
kindly add 2 if function in the code
1 - if rws smaller than or equal 11, then remove the contents ( inside the table ) - i dont know if this possible or no, bcoz u dont where how the range will be
2 - if rws =11 then clear contents range B2:L11
thanks very much
Last edited by Undo; 07-19-2019 at 12:52 PM.
is my explain clear?, waiting for editing
thanks
Administrative Note:
Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
@porucha
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question/answer relates to. Members tailor answers based on your Excel version. Your profile says "old" ??????
@pepe
noted,sorry
Did you try his new code in #9?
thanks.. solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks