understanding

So I have a project that I am going to start. I will be writing the code in VBA, to automate some manually processes that I do. Just looking at my data, I think that the best approach is going to involve using (an) array(s). I don't have too much experience using them. Once provided to me I can...

Hi can anyone recommend some good sites or books for a rookie to provide a basic understanding of VBA in Excel? Any hints gratefully appreciated! Ali

Good morning I tried few of the suggestions from google but still can't get it done right. I need to find the value from corresponding date & time. Here is a pic for easier understanding - Im trying to fill all the cells in column G with the corresponding data from column C The first example...

Can anyone explain this formula and what it is doing? The OFFSET is confusing me. =IF(OR(ISBLANK(M67),ISBLANK(C67)),"",IF(OR(ISBLANK(N67),Q67=0,Q67=-1),(L67-M67)*100/D67,((L67-M67)-(AVERAGE(OFFSET(O67,(Q67+1),0)/300*N67,OFFSET(O67,(Q67+(IF(OFFSET(A67,Q67,0)="SEED",0,1))),0)/300*N67)))*100/D67))

Hello All, I have been using some of the error handlers in my scripts. Well, i am an online learner and have learned most of these stuffs from videos where i did not get the opportunity to ask some questions. So i need help with the understanding of these error handlers. For example "on error...

I understand that all these formulas add (except no. 5), but what I really want to know is what do they mean 1) IF(OR(C11<>0,C12),C11+C12,"") 2) IF(OR(ISNUMBER(C10),ISNUMBER(C13)),SUM(C10)+SUM(C13),"") 3) IF(OR(C15<>0,C16),C15+C16,"") 4) IF(SUM(C11:N11),SUM(C11:N11),"") 5)...

Hello, I am trying to understand classes using VBA Excel. I am having a hard time digesting the whole idea of them. Can someone explain to me or direct me to place that was useful to you? I am looking for detailed examples. I have a vague understanding of them. Any help would be greatly...