Paste Down Macro....,

[rajuctech]

Hi guys

Would you please suggest this how to write a macro paste the below blank cell....,(column A, B, C)
A B C
<table border="0" cellpadding="0" cellspacing="0" width="240"><col style="width: 69pt;" width="92"> <col style="width: 38pt;" width="50"> <col style="width: 74pt;" width="98"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 69pt;" width="92" height="20">Product</td> <td class="xl64" style="border-left: medium none; width: 38pt;" width="50">Region</td> <td class="xl64" style="border-left: medium none; width: 74pt;" width="98">New Region</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">Glue Guns</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">East</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Africa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Asia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Australia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Brazil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">China</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Latin America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Africa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Asia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Australia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Brazil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">China</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">India</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Latin America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">South</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Africa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Asia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Australia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Brazil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">China</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">India</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Latin America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">Light Sabres</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Africa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Asia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Australia</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Brazil</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">China</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">India</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Latin America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">North America</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">Transponders</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">South</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Africa</td> </tr> </tbody></table>

 

[VoG]

Select the columns with blanks, press F5, click Special, tick Blanks and click OK

Press =

Press Up arrow

Hold down CTRL and press Enter.

 

[Andrew Poulsom]

If you want a macro:

Sub Test()
    Dim Cell As Range
    With ActiveSheet.Range("A1").CurrentRegion
        For Each Cell In .SpecialCells(xlCellTypeBlanks).Cells
            With Cell
                .FormulaR1C1 = "=R[-1]C"
                .Value = .Value
            End With
        Next Cell
    End With
End Sub