y.value

  1. D

    Type mismatch error

    Hi, I am getting a Type mismatch error of the below italic line. I cannot see where the problem is. Can anyone help (the macro goes down column Y and deletes entire row if cell in column Y is B or is C); Last = Cells(Rows.Count, "A").End(xlUp).Row For i = Last To 1 Step -1 If...
  2. S

    Advice about use of .value in VBA

    Hi, I am working on simplifying my code to make it easier to follow and check for errors, and I am wondering how often the suffix .Value is needed to determine the value of a cell reference. I would imagine you need the .Value to assign variables (eg x = Cells (r, c).Value) but is it necessary...
    • SR1
    • Thread
    • .value advice cells needed y.value
    • Replies: 1
    • Forum: Excel Questions
  3. K

    Manipulate jQuery to change display length on website

    Hi, I am currently working on a code in order to scrape data from a Company page in order to make a list of Projects available in Excel (as our programmers are too busy to implement this function directly). I combined several bits and pieces i found on the web, and it works like a charm, apart...

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