Column B:D are merged for each row.
I have a formula in b16 that I want to copy to B17:b43 using a macro.
I use the following code:
Range("b16").Select
ActiveCell = ("= VLOOKUP(E15,[logs.xls]salesloghidden!$F:$H,3,FALSE)")
ActiveCell.Copy
Range("b16:b43").PasteSpecial (xlPasteFormulas)
This works except for:
row 32 to 41 it is pasting the formula in two cells even though they remain merged.
41 to 43 it is pasting in all three cells even though they remain merged.
Visibly you can see the info overlapping in the merged cells, but if you select itthe cells act as one and retain the merged property.
Any ideas????????????
I have a formula in b16 that I want to copy to B17:b43 using a macro.
I use the following code:
Range("b16").Select
ActiveCell = ("= VLOOKUP(E15,[logs.xls]salesloghidden!$F:$H,3,FALSE)")
ActiveCell.Copy
Range("b16:b43").PasteSpecial (xlPasteFormulas)
This works except for:
row 32 to 41 it is pasting the formula in two cells even though they remain merged.
41 to 43 it is pasting in all three cells even though they remain merged.
Visibly you can see the info overlapping in the merged cells, but if you select itthe cells act as one and retain the merged property.
Any ideas????????????