T
Thorsten Gleumes
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
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