Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB PasteSpecial when range changes
Dear Friends,
I have a list of names in column A that changes each time I run a concatenate macro I have created. The number of different names is never the same. I would like a way to copy the complete list of names and paste-special then to column B. I want to paste-special I do not want the concatenate formula to copy, only the values. Then I need to delete column A. Next, I need a way to export to a simple text file (called Name List.txt) the entire list of names. Thank you in advance for your help. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PasteSpecial / Formats also pastes a random range name | Excel Discussion (Misc queries) | |||
vba pastespecial | Excel Programming | |||
PasteSpecial problem | Excel Programming | |||
A More Effective Way of Using PasteSpecial? | Excel Programming | |||
pastespecial | Excel Programming |