balikbayan baks

September 15, 2006

vba for excel

It's weird that I'm using Visual Basic Applications for Excel instead of just using the hundreds of built-in functions one can find in the spreadsheet app. Probably because it is tiring to look for the functions that will address your needs. But in VBA, I also look for the functions that I can use for an object. Good thing nasa email ko pa yung long test #3 sa BioMed na ang basis naman ay yung ginawa kong MTTR computation nung OJT.

Siguro hindi ko lang talaga alam na may function na ganito, pero since I'm only using the functions that I know [ Sheet(SheetName).Select, Cells(row,column),etc ], the applications I develop highly depend on the exact location of a cell that you want to evaluate. A parallelism of this limitation is the absolute positioning in HTML/CSS.

Saka ko na hahanapin kung may paraan na hindi ganun ka-manual ang maghanap ng cell sa mga worksheet. hehehe

No comments: