VBA code help
VBA code help, variables?
Tue, 09/20/2011 - 13:55 — Anonymoushey guys i've been working on this code for a while and can't seem to get the right answer, it keeps stopping where one of the variables im trying to find is zero but i want it to calculate that still, i just want it to stop once it finds a blank cell in one of the variables like the last cell which is normally blank, what can i do to fix this?
Sub power()
Dim i As Double
Dim j As Double
i = 3
While Cells(i, 6) <> 0
Debug.Print Cells(i, 6)
Cells(11, 2) = Cells(i, 6).Value
Debug.Print Cells(12, 2)
Cells(i, 8) = Cells(12, 2)
Debug.Print Cells(i, 8)
i = i + 1
Wend
En
More on hypeanswer.com
More on Wikipedia
- India - Wikipedia, the free encyclopedia
India, officially the Republic of India (Bharat Ganrajya) [c], is a country in South Asia. It is the seventh-largest country by area, the second-most populous country ... - Canada - Wikipedia, the free encyclopedia
Canada is a North American country consisting of ten provinces and three territories. Located in the northern part of the continent, it extends from the Atlantic to ... - Wikipedia, the free encyclopedia
From today's featured article Juwan Howard (born 1973) is an American professional basketball player who plays for the Miami Heat of the National Basketball ... - Facebook - Wikipedia, the free encyclopedia
Facebook is an online social networking service, whose name stems from the colloquial name for the book given to students at the start of the academic year by some ... - Internet - Wikipedia, the free encyclopedia
The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite (TCP/IP) to serve billions of users worldwide. It is ... - China - Wikipedia, the free encyclopedia
China, officially the People's Republic of China (PRC), is a sovereign state located in East Asia. It is the world's most populous country, with a population of over ... - Ronald Reagan - Wikipedia, the free encyclopedia
Ronald Wilson Reagan (pron.: February 6, 1911 – June 5, 2004) was the 40th President of the United States (1981–1989). Prior to that, he was the 33rd Governor of ... - Australia - Wikipedia, the free encyclopedia
Australia, officially the Commonwealth of Australia, is a country comprising the mainland of the Australian continent, the island of Tasmania and numerous smaller ... - Help:IPA for English - Wikipedia, the free encyclopedia
Throughout Wikipedia, the pronunciations of English words are conveyed by means of the International Phonetic Alphabet (IPA); for a basic introduction to IPA, see ... - Europe - Wikipedia, the free encyclopedia
Europe is, by convention, one of the world's seven continents. Comprising the westernmost peninsula of Eurasia, Europe is generally divided from Asia by the watershed ...
Answers
News
