Debug: How to debug this code?

Hi All,

I've written a macro that is supposed to do the following once it is execute:

1) Requests the user to click on a cell (to get its row value)
2) Use the row value to get a range of values over 3 cells in steps of 5 across the column (essentially I'm taking data values across a table whose type repeats itself every 5 columns)
3) Pasting the values in a table in a different sheet but down a row instead of across a column

The code compiles and executes but I get no values in the target table. There isn't even an error. So I'm wondering, how does one go about debugging the thing?

Please Login or Register  to view this content.

I think the idea for me to debug is to find out what the values of TrendRng and RptVal hold at any one time. I tried debug.print but somehow couldn't get it to work...any ideas?

Found the issue. The code is printing the values into the next sheet but its all over the place and it is not iterating as I thought it would...

Using the 'step' debug key (F8), I found that the code was spending most of the time in the For x loop rather than running through the 'For i then...' loop then 'For x then' loop and repeating at the 'For i then...' loop if you get what I mean. Maybe it has to do with the placement of the next i, next x lines....I'll experiment with it but if anyone has an improvement suggestion I'm all ears

Hi romperstomper,

I'll illustrate the intention of my macro with a picture --> macro-intention.jpg

Thanks.

reach