Help to divide a number from a variable cell

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?

Please Login or Register  to view this content.

Originally Posted by :) Sixthsense :)

This will do it for you

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

thanks Sixthsense. I used the last line of code but still get the same error:

Run-time error '11':
Division by zero

thanks to you both. I had it around the wrong way but I have since used:

Please Login or Register  to view this content.

It appears to be working ok but I will need to do some checking and testing.

I now need to multiply this number by 100 (to get to a percentage), but I have used this with no success:

If Sheets(j).Cells(i, 4).Offset(2).Value <= (100 / Sheets(j).Cells(i, 4).Offset(3).Value * 100) Then

Is that correct?

So e.g. my cell has 3 in it. I need to do 100/3 = 33/100 = 0.33

got it (I think) by using this:

Please Login or Register  to view this content.