rangeab

  1. D

    If statements in VBA includes code to go to lastrow + 3 rows down

    I have a spreadsheet that has the following: Column AB has code to go to the lastrow + 3 rows and uses a SUMIF function; lastrow + 4 rows and uses a SUMIF function and lastrow + 5 rows and uses a SUMIF function: Range("AB" & lastrow + 4).FormulaR1C1 =...
  2. V

    vlookup only in a cell when the row is selected

    Hello all I am trying to complete a Vlookup in column "AB" but only on the active row you select and then run a macro This is the line I added to my macro but it's not correct [Contact = Range("AB" & ActiveCell.Row).FormulaR1C1 = "=VLOOKUP(RC[-14],'Site Names'!C[-26]:C[-25],2,FALSE)"]...
  3. V

    Vlookup on active line

    Hello all I am trying to complete a Vlookup in column "AB" but only on the active line that you enter into This is what I have tried [Contact = Range("AB" & ActiveCell.Row).FormulaR1C1 = "=VLOOKUP(RC[-14],'Site Names'!C[-26]:C[-25],2,FALSE)"] Any ideas please to correct this so that it works

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