How do I put a Incremental counter in VBA

[Lalit Mahajan]

Hi All,

I have written a Macro (Copyrel) in the attached file, which is for copying the text from one cell (same row and the column varies) and pasting it in the 5th and the 10th column of the same row.

But it runs only for one row, and I have to amend the VBA code everytime for a new row.

Is there any command (or Incremental counter) which I can write in the VBA code, so that the row number gets incremented by 1 and I dont have to amend the code.

Please advise.

Thanks,
Lalit

 

[Somendra Misra]

Hi Lalit,

See the attached file. It uses a FOR loop as an incrementer. This is one way out of numerous ways.

Regards,

 

[Lalit Mahajan]

Hi All,

I have written a Macro (Copyrel) in the attached file, which is for copying the text from one cell (same row and the column varies) and pasting it in the 5th and the 10th column of the same row.

But it runs only for one row, and I have to amend the VBA code everytime for a new row.

Is there any command (or Incremental counter) which I can write in the VBA code, so that the row number gets incremented by 1 and I dont have to amend the code.

Please advise.

Thanks,
Lalit

 

[Lalit Mahajan]

Thank you SM. Appreciate your response.