downward

  1. N

    With Range and AutoFill Question

    Hi, I have a simple with formula but it's not copying down correctly. Sheets("WOs (DSP Only)").Select With Worksheets("WOs (DSP Only)") With .Range("A2:A" & Lastrow) .Formula = "=L2&""-""&K2&""-""&Z2&""-""&X2" End With With .Range("B2:B" & Lastrow) .FormulaArray =...
  2. Nelson78

    Vba: defining a range with reference A1

    Hello everybody. I need to define a range from A1 (top left of the range) to the last populated cell on the right, and to the last populate row downward. https://imgur.com/a/keBiXeZ In this case, the range has to be A1:D21. Consider other cells in other areas could be populated. Thank you.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top