| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate then Fill Down
Hi
I have the VBA CODE of 24 lines Range("A2").Formula = Range("AA2") & " / " & Range("AG2") & " / " & Range ("AI2") Range("B2").Formula = Range("AA2") & " / " & Range("AG2") & " / " & Range ("AI2") Range("C2").Formula = Range("AA2") & " / " & Range("AG2") & " / " & Range ("AI2") ,,,,,, Range("V2").Formula = Range("AA2") & " / " & Range("BQ2") & " / " & Range ("BT2") I want to fill these 24 columns down to lastrow in the Column AA. I dont want to use R1C1. Thanks in Advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201005/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Erase fill print then bring fill back | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Concatenate Countif formula for VBA fill-in | Excel Discussion (Misc queries) | |||
Threaded Mode
