$$Excel-Macros$$ If Find returns error, how do I compose my following code with this error? (VBA)

e However, if this variable name could not be found, I would like to show a message box. I tried to use ISERROR, but it doesn't work. If IsError(Range(Range("A1"), Range("A1").Offset(0, MsgNum)).Find(what:=TestCellName, lookat:=xlWhole, LookIn:=xlValues, searcho

$$Excel-Macros$$ How to get the address of a cell in VBA

Range("A1") directly. Thanks Mao -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.lin

$$Excel-Macros$$ How to turn on the auto list for Excel Function?

op up. The only thing I need do is to hit "tab" instead of filling the characters one by one. Which step can bring this auto filling back alive to my Excel? Thanks in advance! Mao -- -- Some important

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

can somebody please transfer it to 2003 version? I don't have 2007 in my company. On Jan 6, 9:40 am, Dave Bonallack wrote: > Hi Kalyan, > The attached works, with the following limitations: > That the data in Col A is always the same (as in your sample data) > That any given BP Name is not repeat