rangeg

  1. M

    Recon / Duplicate VBA Freezing when used on 100-200k or more rows.

    Hi Forum, I have written a piece of code that does reconciliation: The first part checks between columns: Sub AutoRecon() Worksheets("Main_Recon").Select Dim i As Long, _ LRa As Long, _ LRb As Long, _ rowx As Long LRa = Range("A" & Rows.Count).End(xlUp).Row LRb = Range("G" &...
  2. P

    Select last used cell And it's Offset

    I would like to use "Range("G" & Rows.Count).End(xlUp)" to determine the last used cell in Range("G"), and select it AND its "Offset(1,0)". I am running into issues when pairing it with the Autofill code from Macro Recorder. See below: What I need to do (This is only an example, and does not...
  3. M

    Loop through sheets with Call macro's

    Hello, I'm trying to make this code work for all my sheets. But after trying for several hours I give up. The problem seems to be that the code doesn't loop through the sheets. Sub NaDataInvoegen() Application.ScreenUpdating = False Call VerwijderMonstervoorbewerking1 Call...
  4. T

    Clear Row Contents (Excluding Column A & N)

    Hi All I have the following code that clears the contents of a row based on the text in cell G. However I need the code to clear contents of the row but exclude anything in Column A and N. Sub ClearIncorrectRows()Dim lRw As Long, n As Long lRw = Range("G" & Rows.Count).End(xlUp).Row For n = 1...
  5. N

    Post the formula instead of value?

    Hi, Hope someone can help me with this. I thought it would be pretty simple to do, and I have tried alot without any luck. So now I come seeking some expertise. Sub Explained_variance() Dim i As Long Dim BALlastrow As Long Dim v As Variant Dim LockedCell As Range Dim j As...
  6. T

    Replacing a long integer with text in VBA

    Hello, This is my first post but I do frequent these forums often trying to figure out how to fix my VBA codes, but I am still struggling with my current issue. Here is what I am trying to do: I am comparing 2 worksheets to see if Product A is on Sheet B, and I have about 80,000 lines to go...

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