findrow2

  1. M

    VBA running the same process on a second worksheet

    I am using the following code to remove items from a list on the current sheet and put them on another sheet. These same items exist on neighboring sheets with different names. It works fine for FindRow and SearchRange, but it's not doing anything to FindRow2 and SearchRange2. I'm not getting an...
  2. A

    To select a range between two cells containing specified text

    Hi All Thank you for your Supporting I have small problem; I copy data between the “Standardization Code: “in single row. The “Standardization Code” part of the sentence I Get below code but thin code not moving next Sub SelectBetween() Dim findrow As Long, findrow2 As Long 'On Error...
  3. P

    Error - SpecialCells Property of Range Class

    Hello All, I'm trying to paste some values in a column removing any blanks that are copied with the following code shown below. I figured I could using special cells with xlCellTypeConstants to do so, but keep receiving the error "Unable to get the SpecialCells property of the Range class"...
  4. S

    Select multiple ranges between two same words in one column

    Sub SelectmultipleBetween() Sheets("sheet1").Select Dim findrow As Long, findrow2 As Long findrow = Range("B:B").Find("idle").Row findrow2 = Range("B:B").Find("proc", Range("B" & findrow)).Row Range("B" & findrow + 1 & ":B" & findrow2 - 1).Select Selection.Copy...

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