View Single Post
  #5   Report Post  
jvoortman
 
Posts: n/a
Default help wanted to clean up a data sheet

not smart enough to understand ... I know how to click Alt F11 and
insert code in a new module, and then once back on excel sheet, do an
Alt F8 to run it. That's the extent of my knowledge....hence the
request for help.

damorrison wrote:
Sub ForNextTest ()
'this will be your starting point
Range("yourRangeHere").select
'this is how many times you want the loop,change the 60 to what ever
you need
For varCounter = 1 to 60
'enter code here
Next
End Sub
test it out, maybe set the counter to 5or 10 to make sure its going to
work properly
dave