consumerbas.blogg.se

The above code uses a For loop to go through each cell in the selection. You only need to add the VBA code to the file once and then you can easily reuse the code multiple times in the same workbook or even multiple workbooks on your system.īelow is the VBA code that will go through each cell in the selection and fill down all the cells that are blank: 'This VBA code is created by Sumit Bansal from You can use a really simple VBA macro code to quickly fill down cells in Excel till the last empty value. If you need to do this fill-down once in a while, I recommend you use this Go-To special and formula technique.Īlthough it has a few steps, it’s simple and gives you the result right there in your dataset.īut in case you have to do this quite often, then I suggest you look at the VBA and the Power Query methods covered next Method 2 – Fill Down Using a Simple VBA Code