Thread: Range in VBA
View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default Range in VBA

Hello,

this is my range:
Set myRng = .Range("E3", .Cells(.Rows.Count, "E").End(xlUp))
It is possible to set my range to jump 2 rows.
Example. E3, E5,E7,E9 INSTEAD E3,E4,E5,E6
--
Regards,
Jeff