如何删除VBA/Excel中X行下方的所有内容? [英] How do I delete everything below row X in VBA/Excel?

问题描述

我有一个包含数字的长变量X.假设是415.

I have a long variable X that contains a number. Say it's 415.

如何从415行及以下删除工作表上的所有内容?

How do I delete everything on the worksheet from Row 415 and below?

我想确保我的电子表格在415行及其下面的所有内容都是干净的.

I want to ensure my spreadsheet is clean in Row 415 and anything else that might be below it.

我该怎么做?谢谢.

推荐答案

听起来像以下内容将满足您的需求:

It sounds like something like the below will suit your needs:

With Sheets("Sheet1")
    .Rows( X & ":" & .Rows.Count).Delete
End With

其中X是一个变量，它=行号(415)

Where X is a variable that = the row number ( 415 )

这篇关于如何删除VBA/Excel中X行下方的所有内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！