ws.cellsa

  1. gheyman

    Code not running to last row

    I have code that is supposed to perform all the way to the last row that has data in column H But it seems to stops right before the last two rows. So if I have all the way to row 739, its not putting data in 738 or 739 column 13 If I add data to H740 and H741 I get data in column M (13) for...
  2. gheyman

    Add an If statement to Code

    I need to add an If statement to this code. If the value in columns E and G are 0 then 1 else.... I want to put a 1 in column 13, for each row, if column 5 and 7 are 0. If its not then ws.Cells(a, 13) = ws.Cells(a, 12) * ws.Cells(B, 12) Sub Add_Quantities() 'Find Parent Qty and my Qty...
  3. S

    Object Doesn't support this property or method runtime error

    Greetings, I am receiving the error "Object doesn't support this property or method" on the line below TA.ws.Range("A1").Select This line exists within the code below For Each ws In PA.Worksheets A = ws.Cells(Rows.Count, "A").End(xlUp).Row Do Until A = 2 If Cells(A...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top