I have unusual question. How to use lastrow in Range but instead to define end of some range, just the beginning of a range? See below.

In my code they are some "empty" cells that are not entirely empty and it causes some problems. I have tried that code to delete them:

With ActiveSheet
   Range("A1:L20001").Value = Evaluate("IF(ROW(" & .UsedRange.Address & "),CLEAN(" & .UsedRange.Address & "))")
End With

But in label software they are still somehow there and the only option is to delete whole "empty" range manually.

Usual application for LastRow: .Range("A2:N" & LastRow)

But I need something like this:

.Range("A" & LastRow &":N200001")

CodePudding user response：

You can use:

.Range(.Cells(LastRow ,"A"), .Cells(200001,"N")).Value = .....