Thread: Code problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default Code problem

On my spreadsheet C3 contains a formula which returns the number 1 and cell
W1 value is 1, in this case the code should skip to Continue1: and not sort
the cells, but it is not. Can anyone tell me why?

If Range("C3").Value = Range("W1").Value Then

GoTo Continue1

End If

If Range("C3").Value "" Then

Range("A4:C8").Select
Selection.Sort Key1:=Range("A4"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

End If

Continue1: