| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy a range
I have asked in other NG. Got some very good answers from very helpful
people (The trouble was that these people assumed that I know a great deal about EXcel...I do not)that left me a little confused. Here is my predicament I have a sheet called db1 The sheet contains data in Col A, B ,C, D,E,F,G,H,I,J I have applied a filter to this sheet. Col A is set to show only NON BLANK lines I want to copy the data currently displayed(Ie NON blank lines) to and other sheet The columns are always the same ones but the number of rows varies all the time. So I need a macro that will copy from ALL and only the visible data. (ie copy the data in the above named columns down to the last row showing . Can/will some one give me the code required to do this. Thanks and Have a very happy 2004 -- Norton Professional 2004 says this email is clean...believe it |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find value and then copy associated range | Excel Discussion (Misc queries) | |||
| Macro copy from range | Excel Discussion (Misc queries) | |||
| macro to copy range | Excel Worksheet Functions | |||
| MACRO TO COPY TO A RANGE | Excel Discussion (Misc queries) | |||
| Macro to copy a range | Excel Programming | |||
Threaded Mode
