LinkBack URL
About LinkBacks
I have a table generated from an ACC system. I have to clear the cell = "" but unable to set dynamic range starting from range("I7"). E.G sometimes from I7 to AA100, sometimes from I7 to R 150, etc.
Please Login or Register to view this content.
I have a table generated from an ACC system. I have to clear the cell = "" but unable to set dynamic range starting from range("I7"). E.G sometimes from I7 to AA100, sometimes from I7 to R 150, etc.
Please Login or Register to view this content.
Last edited by missbb; 05-18-2020 at 10:28 AM.
This part of your code is a little confusing. If MyCell is blank, then there are no contents to clear. Please clarify. Also, what is the purpose of column N?Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi, e,g, when you use isblank(I9), it is false. There are many cells without value but is non-blank. So I need to clearconten. Column is for me to check no. of empty cell.
What does I9 contain that gives you a "False" result?
How aboutPlease Login or Register to view this content.
I don't know because the file is generated from an accounting system.Originally Posted by Mumps1
Hi, Fluff13, it is perfect. thank you very much.
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks