在EXCEL的A1到A5里依次有数据:1,5,2,6,3.能将A1:A5中的除3余2的数删除掉后并在B1:B3中输出未删掉的数据吗?要求做成VBA,将原始数据范围(在本题中原始数据范围是:A1到A5)、条件(在本题中条
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/28 19:47:32
![在EXCEL的A1到A5里依次有数据:1,5,2,6,3.能将A1:A5中的除3余2的数删除掉后并在B1:B3中输出未删掉的数据吗?要求做成VBA,将原始数据范围(在本题中原始数据范围是:A1到A5)、条件(在本题中条](/uploads/image/z/11953681-25-1.jpg?t=%E5%9C%A8EXCEL%E7%9A%84A1%E5%88%B0A5%E9%87%8C%E4%BE%9D%E6%AC%A1%E6%9C%89%E6%95%B0%E6%8D%AE%3A1%2C5%2C2%2C6%2C3.%E8%83%BD%E5%B0%86A1%EF%BC%9AA5%E4%B8%AD%E7%9A%84%E9%99%A43%E4%BD%992%E7%9A%84%E6%95%B0%E5%88%A0%E9%99%A4%E6%8E%89%E5%90%8E%E5%B9%B6%E5%9C%A8B1%EF%BC%9AB3%E4%B8%AD%E8%BE%93%E5%87%BA%E6%9C%AA%E5%88%A0%E6%8E%89%E7%9A%84%E6%95%B0%E6%8D%AE%E5%90%97%3F%E8%A6%81%E6%B1%82%E5%81%9A%E6%88%90VBA%2C%E5%B0%86%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%E8%8C%83%E5%9B%B4%EF%BC%88%E5%9C%A8%E6%9C%AC%E9%A2%98%E4%B8%AD%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%E8%8C%83%E5%9B%B4%E6%98%AF%EF%BC%9AA1%E5%88%B0A5%EF%BC%89%E3%80%81%E6%9D%A1%E4%BB%B6%EF%BC%88%E5%9C%A8%E6%9C%AC%E9%A2%98%E4%B8%AD%E6%9D%A1)
xSn@~z,"SX>@P
hFiF}OBgYӠ{+~Y+$g/^zj
e퐙:kX2}# 'ψ, j!-hdЎ'¡8Vj)NݏPX3AyO46ςaEUJ%>|) _A) 3oO-{
`L:όzCzʛwѿ^8#KއpQÒhS[H ,%ptP1`A`=Gs