rjacmuto32
Board Regular
- Joined
- Jul 14, 2004
- Messages
- 98
I have 101 rows of data with row 1 being my header row. I want to do a macro to highlight every 10 rows all the way to the end. So I want rows 11,21,31,etc to be highlighted. I also would like to copy whatever is in column B to a new worksheet. So I'm trying to highlight rows 11,21,31 and then copy cell b11,b21,b31, etc into a new worksheet.
Thanks.
Thanks.