I'm trying to loop through columns and have gotten stuck. The macro works, but only on Column A and I need it to do the same thing to 5 rows. Basically, this is what I need to do:
Range("a8").Select
(do something special with this data)
Range("a9").Select
(do something special with this data)
Range("a10").Select
(do the same thing to all the cells through cell A371 )
Here is where I am stuck... I need it to move on to "b8" and do the same thing, then on to "c8" or until there is no data in row 8.
I hope this makes sense. I greatly appreciate any help!!
Range("a8").Select
(do something special with this data)
Range("a9").Select
(do something special with this data)
Range("a10").Select
(do the same thing to all the cells through cell A371 )
Here is where I am stuck... I need it to move on to "b8" and do the same thing, then on to "c8" or until there is no data in row 8.
I hope this makes sense. I greatly appreciate any help!!