| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to limit fill-down rows
I have a formula that needs to be copied down column E alongside imported
data in column D. The number of rows that the imported column D has varies with each import. How can I set my fill-down rows for the formula to match up with column D? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to limit fill-down rows
Jim posted this to a similar question. I have copied his post to this reply.
------------------------------------------------------------------------ There are many way to do that. Here's one: Range("B1", Range("B1").End(xlDown)).Offset(0, 1).FillDown -- Jim Rech Excel MVP ------------------------------------------------------------------------ "Mike Fogleman" wrote in message ... I have a formula that needs to be copied down column E alongside imported data in column D. The number of rows that the imported column D has varies with each import. How can I set my fill-down rows for the formula to match up with column D? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to limit fill-down rows
This doesn't seem to work. Here is my code for cell E1, and I want it to
fill down to wherever column D data ends. Range("E1").Select ActiveCell.FormulaR1C1 = _ "=CONCATENATE(CONCATENATE(IF(LEN(RC[-4])=5,LEFT(RC[-4]),LEFT(RC[-4],2)),""/" ",LEFT(RIGHT(RC[-4],4),2),""/"",RIGHT(RC[-4],2)),"" "",CONCATENATE(IF(LEN(RC[-3])=3,LEFT(RC[-3]),LEFT(RC[-3],2)),"":"",RIGHT(RC[ -3],2)))" Range("E1", Range("E1").End(xlDown)).Offset(0, 1).FillDown Can you see what is wrong here? "Tumbleweed" wrote in message ... Jim posted this to a similar question. I have copied his post to this reply. ------------------------------------------------------------------------ There are many way to do that. Here's one: Range("B1", Range("B1").End(xlDown)).Offset(0, 1).FillDown -- Jim Rech Excel MVP ------------------------------------------------------------------------ "Mike Fogleman" wrote in message ... I have a formula that needs to be copied down column E alongside imported data in column D. The number of rows that the imported column D has varies with each import. How can I set my fill-down rows for the formula to match up with column D? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to fill in rows with blanks | Excel Discussion (Misc queries) | |||
| Macro Formula for counting rows and doing a fill in afterwards | Excel Worksheet Functions | |||
| How do I limit the visible rows in Excel? | Excel Discussion (Misc queries) | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
| the limit on how many rows can be in one spreadsheet | Excel Worksheet Functions | |||
Linear Mode
