rangeb2.select

Hi good morning, I have the code that works great apart when the name cant filter on the name I M2, it goes on a loop about times, until it finally stops and highlights empty fields, is there anyway t stop the loop and return nothing straight away instead? Private Sub dofilter()...

All - I know this Macro can be cleaned - can someone please help me? I also wanted to know if I can change the value of my H and AH columns to only auto fill based from the value of number rows on B. Thank you so much!!! Rows("2:2").Select Range(Selection, Selection.End(xlDown)).Select...

Hi guys, i have in column A a registration number, and i want to insert a column to add a countif formula to calculate how many times a number appears in my sheet. I had no problems in doing so but i want to know how to write the code so that the countif formula to stop at the last number in...

Hello, I have a table like in attachment and I would like to sort data like in table below. If cell.Value in B1 is > 0 then I want to insert numbers of rows below = how many cells on the right have value > 0, then I want to copy those numbers in this cells below - transpose. In this case I need...

Hi, So I have a macro code that looks like this: Sub DragDown123() ' ' DragDown123 Macro ' ' Sheets("Sheet2").Select Range("B2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet1!C1:C2,2,FALSE)" Range("B2").Select Selection.AutoFill Destination:=Range("B2:B5")...