Re: Any way to deselect a select in VBA?
Here's an example of my code working so that you can see it. Check the cells beforehand to see the formulas, then press the button. Check the cells afterwards and you will see there are no longer formulas, just values. There are also 2 hidden sheets - these sheets will also have the formulas replaced by values, feel free to check before and after.
You can adapt this to see how it should work.
Re: Any way to deselect a select in VBA?
you can change the formatting of a range like so:
Those are some examples that you can use to adapt your code. You could probably just use an =IF() formula to replace the 0 values with a blank string.
Hello,
Try this:
Application.CutCopyMode = False
Workbooks("EXCEL NAME").Close False
know this is old.. But if someone else needs an answer.
Range.select gives a selection object.
After you are done with it, you can recycle the selection object by
selection.start =Selection.End
That way selection object is deselected.
That may be true in Word, but it won't work in Excel, I'm afraid.
Mert_in
. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post
All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.
How to use code tags
Note: no apostrophe in the tags, just used for demonstration here.
['code]
your code goes between these tags
['/code]
Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.
Thanks.
The last code selects a range, the opposite of what was requested
Normally, if you want to deselect a cell or multiple cells from a selection, you just need to hold down the CTRL key and click on the cells you want to deselect. If you want to unselect a range of selected cells, you need to hold down the CTRL key and drag the range you want to deselect.
Thanks
