Loop relative rows

P

PST

Hello
With the macro macro_C(), I call the macro C_N all the 28 rows.
Select column 17 of each row for puts the result of C_N at it

How to make so that C_N holds account of the values of column 1 with
that of the last nonempty cell of the line in progress of lig

Sub macro_C()
Dim lig As Integer
Dim Col As Integer

For lig = 1 To 100 Step 28
For Col = 1 To 1

Next
Cells(lig, 17).Select
Call C_N
Next
End Sub

thank you
 
B

Barb Reinhardt

I think what you want is something like this:

Call Testing(lastEntry)

Sub Testing(lastEntry as variant)
blah blah blah
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Boucle sur ligne relative 1
Loop relative rows 1
Macro Loop 0
permutations combinaisons 1
permutation combinaisons 1
permutation combinaiisons 0
combinations 0
VBA Coding Help for Beginner 0

Top