Do Loop Until result equal 0

[MaxJan]

Hi, All:
Thanks for losting your time trying to help me.
I am new in Excel VBA and i have a problem.
I attached an excel workbook include 2 sheets.
Sheet1 has vba code (I founded by google after 2 days searching and studying loop functions) to do this loop function as :
C1=A1*B1
C2=A2*B2
C3=A3*B3

Do Loop Until result equal 0

My problem in sheet2
I want the same code in sheet1 but application on COLUMNS.
I want this code to do as following:
A3=A1*A2
B3=B1*B2
C3=C1*C2

after one another day trying all i can do the first 2 columns
can any one help me to make it for 1000 columns (REMARK: NOT UNTIL EQUAL TO ZERO AS PER SHEET1).
PLZZZZZZZZZZZZZZZZZ
SORRY FOR BAD ENGLISH

Test 1.xlsm

Moderator's Note: Thread title changed to comply with rule #1 as per the forum rules, but please comply next time yourself…Thanks.

[mike7952]

Give these a try

Please Login or Register  to view this content.