thanks to you both. I had it around the wrong way but I have since used:
It appears to be working ok but I will need to do some checking and testing.![]()
If Sheets(j).Cells(i, 4).Offset(2).Value <= 100 / Sheets(j).Cells(i, 4).Offset(3).Value Then
thanks to you both. I had it around the wrong way but I have since used:
It appears to be working ok but I will need to do some checking and testing.![]()
If Sheets(j).Cells(i, 4).Offset(2).Value <= 100 / Sheets(j).Cells(i, 4).Offset(3).Value Then
got it (I think) by using this:
![]()
If Sheets(j).Cells(i, 4).Offset(2).Value <= 100 / (Sheets(j).Cells(i, 4).Offset(3).Value * 100) Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks