Hi,
I am looking to copy some data from one worksheet to another, based on a number of variables,
One of these includes to divide a number found in a cell by 100. However I can't get it to work.
I get a "Division by zero" error.
Can anyone please help out?
For i = 10 To lastrow Step 11
'start the copy based on criteria
If Sheets(j).Cells(i, 1).Offset(9, 1) = "Ly" Then
'equal to or > 10 criteria
If Sheets(j).Cells(i, 4) >= 10 Then
'equal to or less than specified %
If Sheets(j).Cells(i, 4).Offset(3, 0).Value <= 100 / Cells(i, 4).Offset(2, 0).Value Then <---here is where I get the error
Bookmarks