A
Angus
I import data from a text file and put it at Column A to Column F (by macro
with using “Edit text import†and “Fill down formulas with columns adjacent
to data†at Data Range Property), and the formula is from Column G to J.
However, the data in Column F is not always filled, sometimes it is blanked.
Therefore the formulas from column G to J is sometimes missing, how to fix it
by VBA.
with using “Edit text import†and “Fill down formulas with columns adjacent
to data†at Data Range Property), and the formula is from Column G to J.
However, the data in Column F is not always filled, sometimes it is blanked.
Therefore the formulas from column G to J is sometimes missing, how to fix it
by VBA.