morinia
asked on
Clearing results from a spreadsheet in VB - Excel 2010
Experts,
I have a spreadsheet in Excel that loads from a query and module that runs in VB. How do I clear the results from a prior run?
I have a spreadsheet in Excel that loads from a query and module that runs in VB. How do I clear the results from a prior run?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There you go :)
I think you should split the points between Randy and myself, with him getting the bulk of them because he answered your original question, and I've requested attention to help you do that.
It is no problem, just glad to help :)
@morinia: Note that there's a difference between Clear and ClearContents. ClearContents removes only the values from the cells, whereas Clear removes the values and the cell formatting.
ASKER
You are correct. What steps do I need to split points.? I don't see an option to "Request Attention".
The Request Attention link is normally in the lower right hand corner of the first post in a thread, but since I already did it for you it's no longer there. You can however click the link in the salmon-colored area at the top of the thread. A moderator will respond soon no matter if you do that or not.
A moderator has reopened this question so that you can reassign the points.
I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
Thanks
Thank you :)
ASKER