Took a VBA course a couple of years ago but man that knowledge went in and out 
I have x number of rows of data. I would like to run a macro that goal seeks by setting each cell in column R to 0 (zero) by changing the cells in the corresponding row in column Q, until there is no more rows with data. there will be no gaps between rows. I've recorded a macro that runs the goal seek every time I click an assigned button or alternatively runs the macro by shortcut but it would be nice to just make the macro run everything at once. I guess it doesn't take a lot of code.
So..who is up for this easy challenge?
thanks in advance, great forum!

I have x number of rows of data. I would like to run a macro that goal seeks by setting each cell in column R to 0 (zero) by changing the cells in the corresponding row in column Q, until there is no more rows with data. there will be no gaps between rows. I've recorded a macro that runs the goal seek every time I click an assigned button or alternatively runs the macro by shortcut but it would be nice to just make the macro run everything at once. I guess it doesn't take a lot of code.
So..who is up for this easy challenge?
thanks in advance, great forum!