excel vba多条件查找:vba多条件查找公式[朗读]

submacro1()dimxrngasrange,firstrngasrangeifleft(range(＂a1＂),3)=＂d1[＂thensetfirstrng=range(＂a1＂)elsesetfirstrng=cells.find(＂d1[＂)endifsetxrng=cells.find(＂d1[＂,firstrng)ifxrngisnothingthenmsgbox＂没有了＂elsemsgboxxrng.rowendifendsub。