Hi,
I have two sheets. I would like to clear the content in a specific cell range on a specific sheet. I am using the following:
shDest.Range("A5:B6").ClearContents
whereDim shDest As Worksheet
Set shDest = ThisWorkbook.Sheets("Filtered Data")
This seems a simple thing to do but it does not work. Can anyone suggest a way to clear the cells of content? Thank you.
something like this
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Thanks John but this is almost the same as I have except for the range specified. As a point of interest, I tried changing my range to "A5:A6" as a test and the code still did not work.
there's nothing wrong with the code-are you sure it's being run? do you have any error handlers that might be suppressing an error message?
Josie
if at first you don't succeed try doing it the way your wife told you to
if you are in sheet1 and insert a button, then add the code on it, you'll see that it works.
thx JPPlease Login or Register to view this content.
Last edited by john55; 05-08-2013 at 11:10 AM.
There are no error handlers and the code subsequent to this piece executes.
How does it not work?
Doesn't clear the specified cells?
Errors?
If posting code please use code tags, see here.
In cells A5 and A6 I have text that does not get cleared. In cells B5 and B6 are numbers that do not get cleared. The code after this piece determines what needs to be written into those cells but the cells need to be cleared first and are not; i.e. the previous text and numbers remain after the execution of this code.
see if it helps you
You have code that clears the cells then puts values in them, but neither works.
That's suggests that the code isn't actually being executed, perhaps you should post the rest of the code?
That is not entirely correct Norie. The code subsequent to this piece works just fine and does in fact post correctly to those cells. The piece that does not work is the clearing of the cells.
Just because later code executes doesn't mean the code before was executed.
Hard to tell though without seeing the rest of the code.
Good point Norie. So the question then becomes, what would prevent that lin eof code from executing?
Who knows without seeing the rest of the code?
Fair enough. Unfortunately cannot send the code as it is proprietary. I will try to debug it. Thank you.
We probably don't need to see it all, just the part leading up to the line(s) that don't appear to be working.
You can expunge any sensitive data.
PS If you do post the code please use code tags.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks