excel - 如何选择列范围中的最后一个单元格？

Question

我正在尝试选择一个范围的最终值并将该值放入单元格 Q4 中。范围是动态的，从第四行开始。

这是我的代码:

Sub test()
    Dim PSpark As Worksheet
    Dim lc As Long

    Set PSpark = Worksheets("ws1")
    lc = PSpark.Cells(4, Columns.Count).End(xlToLeft).Column

    With PSpark            
        .Range("Q4") = lc.Value
    End With
End Sub

任何帮助将不胜感激。

Answer 1

非常接近，我想你想要这个:

因此，我们使用您找到的列号，然后在最后一列中选择第 4 行的值。我们将值复制到单元格 Q4。 Cells(row, column)

Sub test()

Dim PSpark As Worksheet
Dim lc As Long

Set PSpark = Worksheets("ws1")
lc = PSpark.Cells(4, Columns.Count).End(xlToLeft).Column 'Gives us the last column number. If the value is in Column C, then we get lc = 3.

    With PSpark

        .Range("Q4") = .Cells(4, lc).Value 'Which row from column lc (which is the last column) we want to copy from

    End With


End Sub