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。