activecell.select

  1. P

    Do Loop running slow

    Hi all I wrote this simple code but it is taking a long time to run. Is there a faster running macro? Range("BA9").Select Do ActiveCell.Select If ActiveCell.HasFormula Then ActiveCell.Select Selection.Copy ActiveCell.Offset(0, -48).Select ActiveSheet.Paste...
  2. R

    trouble with Selection.Find

    the code below works fine until it no longer finds what I am looking for (example is AR) When it has found the last of "AR" I get an error to debug and the section from Selection.find to False).Activate is highlighted yellow. Any help would be really appreciated. Sub ARK_DEP() For i = 1 To...
  3. C

    Search through a range for a date greater than specified cell

    Hi In Cell G1 I have the date 31/3/17 (UK - i.e. 31st March 2017) In Cells B8 to B20 I have a list of dates. I need to loop through these cells and stop once I reach a date greater than that specified in G1. I had an attempt, being the following, but it doesn't work: Range("B8").Select...

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