On Feb 21, 12:25*am, "JLGWhiz" wrote:
Need to modify the code.

Private Sub Worksheet_Change(ByVal Target As Range)
* *If Target = Range("E3") Then
* * * If Range("B2").Value "" Then
* * * * *Range("A8").Select
* * * Else
* * * * *Range("B2").Select
* * * End If
* *End If

It sees the formula as greater than zero, but not the empty string.

"robzrob" wrote in message

...



I'm inputting data in E3 and after I hit enter I want B2 to be
selected. *But only for E3 and only in one worksheet. *And possibly a
further step... *Sometimes the formula in B2 has picked up data from
another place depending on what value was entered in E3. *If it's done
this then I won't need to go to B2, I'd want to go to A8 after E3
instead of B2.- Hide quoted text -

- Show quoted text -

Spoke too soon! I have another macro in this workbook which, after
the workbook has been used, clears all the values from all the cells -
including E3. Now it won't work because when it gets to this line

Range("E3:E5").Select
Selection.ClearContents

in my code, 'your' code is activated and it all come to a standstill.