g.value

  1. R

    A column has a list of dates, some as [Date] Format and others as [General]

    I'm looking for a VBA way to convert these troublesome dates. I have a range of dates from January to December, however there are two rogue dates placed in that reoccur a couple hundred times each. These dates are 31/01/2019 and 28/02/2019 - these are mixed in with actual date-formatted...
  2. M

    Loop and If - If condition is met, but loop jumps over it

    Hi! I can't solve a problem, and I would be really gladful if somebody could help me with my code. While debugging, it jumps a huge. What can be the problem? Cells(j,g).Value = "anxious" temp = "anxiety" If Left(temp, 3) = Left(Cells(j, g).Value, 3) Then 'It's true, code goes on (anx = anx)...
  3. M

    Delete row Content specific

    I have the below program for delete row if specific value content in column . but it getting too much time for running . I want to run the same program but take less time. Also help me for the run that program for different sheet (Sheet2) Sub DeleteRowContents() last =...
  4. C

    Formula stopped working.

    So this worked fine a few months which was the last time i used it but every time i run it now it says Run-time error 13 Type Mismatch Sub DeleteRows() Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "G").End(xlUp).Row For i = iLastRow To 1 Step -1 If...
  5. B

    Copy Data to Row 5 VBA

    Good afternoon I am trying to copy data from worksheet "Project" column G "Over" to inserted sheet "Over" to row 5 of the new sheet. Code I am using is copying the header row (row 4) and breaking at that point. Not sure what is going wrong. Sub Project() Dim i As Long Dim...

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