elmnas
06-22-2015, 05:37 AM
Hello People,
How do I loop through a whole column from row 2 to last used cell in column L?
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
Thank you in advance.
How do I loop through a whole column from row 2 to last used cell in column L?
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
Thank you in advance.