Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

dlskjf f
I am trying to sum while running a loop. I want to add all the positive numbers from cell A1 to A10. I am a newbie, please post better code?
Sub result()
Dim randomNumbers As Range
For Each randomNumbers In Range("a1:a10")
With randomNumbers.Offset(0, 1)
Select Case randomNumbers.Value
Case Is >= 0
.Value = randomNumbers.Value
Case Is <= 0
.Value = 0
End Select
End With
Next randomNumbers
End Sub
1 AnswerSoftware6 years agoNeed Vba help?
I want to take the column name of each column and associate that with the value under that column name. Each column will be different number of rows. There are x number of columns. So if the first column is D, the column name is let's say fruits and D2 is apple and D3 is banana. I want to have in A1 and A2 fruits and B1 as Apple and B2 be banana. Do it until all value have been first column is copied over to columns A and B, then move on to column E until all columns are done. Is there a way to do it excel without vba? If not, can you please provide the macro to this? Thanks in advance.
1 AnswerSoftware7 years agoExcel Vba help?
I want to take the column name of each column and associate that with the value under that column name. Each column will be different number of rows. There are x number of columns. So if the first column is D, the column name is let's say fruits and D2 is apple and D3 is banana. I want to have in A1 and A2 fruits and B1 as Apple and B2 be banana. Do it until all value have been first column is copied over to columns A and B, then move on to column E until all columns are done. Is there a way to do it excel without vba? If not, can you please provide the macro to this? Thanks in advance.
1 AnswerProgramming & Design7 years agoCopying equations in excel?
Hi, i am trying to compare data in column A, basically to compare if a cell is equal to the value right below it (cells A1 to A10 are filled with values). So my equations starting at cell A15 is =A1=A2, A16 is =A3=A4, A17 is =A5=6, etc but if i were to fill/or drag it down, cell A18 isn't =A7=A8. Is there anyway to do this without VBA?
3 AnswersSoftware9 years agowho is the #1 credit rating agency?
who is the #1 credit rating agency in the U.S.? Moody's or S&P? I know fitch is place third. Please provide sources.
1 AnswerCredit1 decade agoIs Mandrill Staffing & Placement a scam?
Hi, i found Mandrill Staffing & Placement, Inc on careerbuilders.com and was wondering if anyone has used this in the past (it's relatively new on careerbuilders). I went to their website and it seems like a scam, all their jobs have no requirements. I google it couldn't find anything helpful. Thanks in advance for any help.
1 AnswerFinancial Services1 decade agoDirect deposit with basic checking.?
Hi, i am currently working for robert half (temp agency), the way i get paid is through direct deposit. The thing is i only have a basic checking account which doesn't allow me to write checks. I was wondering would it be possible for me to get direct deposit for my checking and saving accounting. By the way my bank is citibank.
5 AnswersPersonal Finance1 decade agohow to find out the current address on my social security card?
and where can i obtained this information. I've called the social security department, they told me that don't have the information with them.
3 AnswersGovernment1 decade agohow long does it take to get your name change on your social security card?
I've changed my name last year in april and they said it takes about 8 weeks for me to receive my a card. I've been waiting and still i haven't gotten it yet (10 months). Is this normal? i was thinking if it was send to a wrong address. If i go to a social security office, are they allow to tell me my address on my social security? Please answer if you know what you are talking about.
2 AnswersGovernment1 decade agoHi, for some reason my laptop won't turn on (not even the green lights) with or without battery.?
I think it's the memory or maybe mobo. i was wondering can a laptop turn on without memory or if the memory is broken. Oh it's a dell
1 AnswerLaptops & Notebooks1 decade ago