Hi everyone
hopefully this is a simple one but my limited VBA experience has me stumped. I want to clear the contents of columns a and b when a is blank. Below is the table of sample data i want to clear cells a4:b7, however this range need to be dynamic based off if column A is blank and b contains something.
a b
1 1011111 500
2 1011157 500
3 1010257 500
4 500
5 500
6 500
7 500
May be
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Unfortunately this did nothing!
Attach a before and after workbook. Pictures are notoriously difficult to try a code on.
BEFORE.JPGAFTER.JPG
before and after atttached
Try this:Please Login or Register to view this content.
Throws a runtime error '424' object required. do i need to set the used range?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
No, UsedRange is built in. Maybe try adding 'sh' before the row and column count?If that doesn't work, can you upload the spreadsheet?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks