How to create output for a specific line in Macro?

[Mosen87]

I have a macro code and I want to make output for some lines. Is there a way? consider the following, I want to see what is the "ActiveCell.Offset(off, 0)"?
Sub Opter()
'Application.ScreenUpdating = False
'Call Module1.Iterations
Do While IsEmpty(ActiveCell.Offset(donum, 0)) = False
If mini = 1 Then
Call selecterMini
Else
Call selecter
End If
Set changev = Selection
ActiveCell.Offset(off, 0).Select

 

[JayM]

In the VBA editor, open the 'Immediate Window' from the VIEW drop down menu or press CTRL+G.

Then add this line of code to your macro at the point you wish to see the value.

Debug.Print ActiveCell.Offset(off,0)

 

[Mosen87]

Thanks. How can I run only that line? When I put the cursor in the beginning of the line and press run into, It runs from the beginning of code which is not what I need.
2) And by doing "Debug.Print ActiveCell.Offset(off,0) " I get the value, how can I get the row and column for this value?

 

[JayM]

Hi Mosen87,

You can execute your code line by line by pressing F8.

To get the address of the cell use;

Debug.Print ActiveCell.Offset(off,0).Address


In my previous reply, the line of code should have read;

Debug.Print ActiveCell.Offset(off,0).Value

Good luck

 

[Fluff]

How about

Debug.Print ActiveCell.Offset(off,0).Address

 

[Mosen87]

Hi Mosen87,

You can execute your code line by line by pressing F8.

To get the address of the cell use;

Debug.Print ActiveCell.Offset(off,0).Address


In my previous reply, the line of code should have read;

Debug.Print ActiveCell.Offset(off,0).Value

Good luck

Thanks JayM
When I press F8, which is the "step into" option in debug tab, It starts from beginning. I want to run only for example line 40. Do you know where I am missing!

 

[Fluff]

Select the line you want to start from & press F9, then press F5, the code will run until it gets to the break point, at which point you can use F8 to step through the rest of the code.

 

[Mosen87]

Select the line you want to start from & press F9, then press F5, the code will run until it gets to the break point, at which point you can use F8 to step through the rest of the code.

Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Mosen87]

Glad we could help & thanks for the feedback.

It worked, thanks