Macro debugging

**VelvetRevolver84** · 06-01-2013, 03:01 PM

Hi, I have the following code which returns a 'Subscript out of range' error when I run it. I have a function with input in cell F2 and output in cell N2. I'd like to take a list of non-null values in column C as inputs and record the corresponding outputs in column D.

Please Login or Register  to view this content.

I'm new to VBA - Could someone please tell me what the problem is?
Many thanks!

**HSV** · 06-01-2013, 03:33 PM

I think your sheetname is without a underscore.
Worksheets("All Data")

Please Login or Register  to view this content.

**shg** · 06-01-2013, 03:33 PM

See http://www.cpearson.com/excel/DebuggingVBA.aspx

What happens when you step through it?

**VelvetRevolver84** · 06-01-2013, 05:51 PM

Getting rid of the underscore fixed the error, but I realized that I also need to move the i = i + 1 outside of End If for it to work properly. Step feature was really helpful. Thanks!