| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill the formulas at adjacent columns by VBA
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data, fill adjacent formulas | Excel Discussion (Misc queries) | |||
| In excel 2007 I can't find the fill adjacent formulas function | Excel Discussion (Misc queries) | |||
| fill down formulas in adjacent columns | Excel Discussion (Misc queries) | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| How do i fill the adjacent cell formulas in user form when i press | Excel Discussion (Misc queries) | |||
Threaded Mode
