View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default for x to - next x question

Try this.

If this helps click Yes
--------------
Jacob Skaria


For x = 2 To lastrow
Range("G" & x) = Right(Range("F" & x), Len(Range("F" & x) )- 1)
Range("I" & x) = Right(Range("H" & x), Len(Range("H" & x) )- 1)
Next x