Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deselect cells with formulas in selection
Hi all,
i have one problem to solve and can't get it done. (I am new to VBA) I have a table with calls that the user can fill and some with formulas. If the user makes a selection mith his mouse (e.g. from A1 to F20), he also selects cells with formulas. What i want to do, ist to deselct these cells by a script/vba program, after the user made his selection, so that only the non-formula cells stay selected. How can i do this? I think it has to be this way, but i don't know how to deselect a cell. 'Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim c As Range For Each c In Target If c.HasFormula Then ??? Next End Sub I this the right way? What is the missing comand? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect (Unselect) Cells | Excel Discussion (Misc queries) | |||
deselect row/column from multiple selection | Excel Discussion (Misc queries) | |||
programmatically deselect a selection? | Excel Programming | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Deselect of Cells | Excel Programming |