Hello people I hade made following code but I dont get it work,
I want to loop through the whole column,
then take the each cellvalue from column "L" *1.35
put the new result same row but column K
I got this code so far
![]()
Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Dim c As Range For Each c In ws.UsedRange.Columns("L").Cells Dim mycell As String Dim nomatchfom As String mycell = c.Value nomatchform = 1.35 myresult = Val(mycell * nomatchform) MsgBox myresult Next c Next ws
Bookmarks