Vba multiplying a whole row by constant if figure appears in column b!!!!!!!!!!!

Hey Guys,

everyone here is always such great help so I thought I would check to see if anyone could help me. So I am trying to create a macro that multiplies a whole row every figure in it based of an IF statement that works if certain word shows up in a certain cell. If the IF statment is satisfied it should only multiply those rows that have a "X" in the B column of that row. I have it work for 1 sheet but I am trying to make this macro apply to the whole work book. I will put a sample of my code below any help would be amazing. Thank you guys so much for your help.
God bless!!

Please Login or Register  to view this content.

Untested. Try on a copy first.

Please Login or Register  to view this content.

Hi,
Thank you so much for responding. I tried the code above and still the same result it only works for 1 sheet. and if I add more sheets to the part of the code where we set lr equal the code will run but it wont multiply on either sheet its like it only works for one or nothing. I changed the code a little I will put it below. Anything will help. you guys are awesome.
Thanks,
your friend

Please Login or Register  to view this content.

Maybe there is another way of approaching this a method that would just keep this argument rue for every worksheet in the workbook. I am not sure.
Thank you