Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste
Is there a way to make a macro / command button that selects all the
values in a column only if they contain information and paste it somewhere else? So say you have a column that has 4 cells in it. cell 1 has: "Hello" cell 2 is: empty cell 3 is "3" cell 4 is "Bye" When you run the macro it will only copy Cell 1, Cell 3, And Cell 4 and paste those into another cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |