Excel/Expert Profile

Average Ratings

• Knowledgeability 9.87
• Clarity of Response 9.80
• Timeliness 9.88
• Politeness 9.98

• Number of Questions (in Past 24 Hours) 1
• Max Questions to be Asked (in 24 Hour Period) 1
• Total Questions (since joining AllExperts) 1951
• Volunteer Since 2001-08-27
• Prestige Points 14394

Recent Reviews from Users

Read More Comments

Recent Answers from Adelaide carvalho

2009-10-29 Please Help Me with a Macro:

Hi Sandy How are you? Please see the following Option Base 1 Sub copying() Rem On Error Resume Next Const LastRow = 200 Dim R As Range, enc As Boolean, LastCol As Integer Set R = Worksheets("Sample

2009-10-27 Excel:

Hi Don How are you? How many miles do you run)? in how many minutes? 4.25/60 is the number of miles per minute? Well, suppose you run 4.25 in 30 minutes Type 4.25 in A1 Type 30 in B1 Type =A1/B1

2009-10-23 Macro to insert date:

Hi Imran How are you? Please see below Sub LastMonth() Dim R As Range, F As Date, F1 As Date Set R = Sheets(1).Range("C4") F = R.Cells(1, 1).Offset(0, -1) F1 = F - 31 R.Cells(1, 1) = F1 R

2009-10-15 Auto numbering Macro:

Hi Ellerd How are you? This formula is fine. But, if you inset a row in, e.g. A23, this new cell doest not get the formula. You have to copy the formula from A22 to the new A23. The only solution

2009-10-12 Multiple if statements to count items that meet two criteria:

Ho Dean How are you? Excel 2007 has the function Countifs do this If you are familiar with VBA, please try the following VBA macro: Sub countingIFSS() Dim R1 As Range, R2 As Range Set R1 = Range("A1:A500")