As you may have figured out by now, you'll have to be more specific. No one, I gather, is willing to try to describe for you how to convert any Excel formula to VBA. If you give us a specific formula, maybe someone will volunteer to help.
(It isn't clear to me that it'll execute faster, though.)