vba autofill formatting

  1. L

    VBA Add FillFormat to MAcro

    This Macro fills Formulas to Last Row I need it to also fill formats as well Dim LastRow As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row Range("W4:AA" & LastRow).Formula = Range("W3:AA3").Formula
  2. S

    VBA Autofill if not blank, then format

    Using Excel 2010 This is going to sound really messy, so I hope you'll forgive me as I'm new to VBA. Let me outline what I'm trying to do: Column A: User fills in file name Column B: Formula to concatenate file name to external file path to create formula (it references cell A2 in different...

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