MaxJan
11-27-2012, 12:34 PM
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).
SORRY FOR BAD ENGLISH
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).
SORRY FOR BAD ENGLISH