| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select/Copy/Paste in Macro/VBA
I'm trying to create a macro to preformat an imported text
file. One of the tasks is to concatenate lastname, firstname, middleinit, suffix that is spread into 4 columns into one column. The number of rows varies with the imported text file. I've tried inserting a blank column and building the concat formula in the top cell, but I'm having a problem copying this formula down to all the cells below while STOPPING at the last cell that has data to the right. Suggestions for this newbie, please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select, find in another book, copy, return and paste | Excel Discussion (Misc queries) | |||
| Not using select for copy and paste | Excel Discussion (Misc queries) | |||
| Select Visible Cells only copy & Paste | Excel Programming | |||
| Select File Copy/Paste Macro Help.... | Excel Programming | |||
| Select All and copy and paste | Excel Programming | |||
Threaded Mode
