Thread
:
same function edit vba excel
View Single Post
#
6
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
same function edit vba excel
Hi,
Am Mon, 9 Mar 2020 01:44:08 -0700 (PDT) schrieb
:
try:
Set ws = Sheets("Sheet1")
With ws
LRow = .Cells(1, "E").CurrentRegion.Rows.Count
For i = 1 To LRow
.Cells(i, "A").Resize(, 3).Value = _
.Cells(i, "E").Resize(, 3).Value
Next i
End With
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch