| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting data to copy and paste
George
Thanks for the interest, but I managed to help myself with: ActiveSheet.UsedRange.Copy from Excel help. Thanks BCB "George" wrote: On Apr 16, 5:10 pm, Black country boy wrote: I have a macro that sorts data into the correct order, then I manually copy and paste into a different application. I would like to write code into the macro that copies the data after sorting, but the length of the data list is variable, i.e. sometimes it could be spread from A1 to A52, sometimes A1 to A105. Each time can give a different length, (but always in column A only). Also, some of the cells are blank, but must be copied as blank. Thanks. Hi, Black Country Boy: Would you please give me an example telling me what you need? I am not sure whether I can solve your problem. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet | Excel Discussion (Misc queries) | |||
| MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet | Excel Worksheet Functions | |||
| Auto copy/ paste on relevant work sheet when selecting list item | Excel Programming | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
Threaded Mode
