rangeg

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" &...

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...

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...

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...

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...

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...