Re: Fill All Rows Across All Columns In Step
How about:
Code
Sub Macro1()
[a1].Resize([a65536].End(xlUp).Row) = 100
[b1].Resize([b65536].End(xlUp).Row) = 150
End SubRegards
Northwolves
Posts by NORTHWOLVES
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.