You are here:
I will be able to answer any question on Excel and Visual Basic for Applications - class modules, recursive procedures and functions are my favourite
Several readers of my Books think they are useful.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Tracey | 01/13/12 | 10 | 10 | 10 | Very quick response and accurate, understood what ..... |
| A | 01/10/12 | 10 | 10 | 10 | |
| H | 11/25/11 | 10 | 10 | 10 | Excellent answer - it works brilliantly and ..... |
| Antonio Vaz | 11/22/11 | 10 | 10 | 10 | mUITO MUITO OBRIGADO aDELAIDE |
| Eric | 11/19/11 | 10 | 10 | 10 | Thanks Adelaide works fine |
Hi James! How are you? Please try the following macro> Sub Macro1() Dim R As Range Y = InputBox("Please type the address where you want to check for the x") Set R = ActiveSheet.Range(Y) K = 6:
Hi SHRISHAKTIPRASAD How are you? I think you mean count instead of sum. If so just replace sum by count Assuming your data is in A1:D7 Please do 1: please type earlier date in f2 and later date
Hi Varghese How are you? Please do the following 1. Run the vba Editor 2. Insert module 3. Copy the code: Sub Ticking() Dim R As Range Set R = ActiveSheet.Range("A1:A100") For Each C In R
Hi Mike How are you? I am sorry but I cannot test your program. I had a look at it though. Please see the following Sub ggg() Dim R As Range Set R = ActiveSheet.Range("B1") N = R Rem Activate
Hi Ecsuraweera How are you? Please have a look at the following code and adjust to your problem Sub whilereading() Dim R As Range Set R = ActiveSheet.Range("a1") y = "" Do y = InputBox("Please
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.